2 Replies Latest reply: Jun 4, 2013 8:13 AM by 1009342 RSS

    Character Set problem when using Microsoft Microsoft ODBC for Oracle

    1009342
      Hi, all

      I am using:
      OS: Windows 7 x64 (client and server)
      DB: Oracle 11g
      ODAC: v. 11.2.0.3.20 32-bit
      Connection string: "Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.221)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=geopoisk)));User Id=uid;Password=pwd;"
      DB NLS_CHARACTERSET: CL8MSWIN1251
      DB NLS_LANGUAGE: AMERICAN
      DB NLS_TERRITORY: AMERICA
      Client NLS_LANG: UKRAINIAN_UKRAINE.CL8MSWIN1251

      When I am trying to access the server through ADO the character set of the values becomes corrupted or wrong. The value should be "Месторождение", but shows "?????????????" instead. When I am trying to connect through Visual Studio 2005 and Oracle client the results of the queries are shown in the right way.