110
« on: December 18, 2018, 07:48:43 pm »
The DB2 client installed is version 7.2, running on AOS.
The DB2 client does come with an ODBC driver manager, but it is version 2.5. The IBM ODBC driver works correctly with version 2.5 ODBC driver managers, the one supplied by DB2 and others that are available.
The version 3 ODBC driver manager I am using works with version 3 drivers, e.g. dbase and text, and with the SQL Anywhere ODBC driver which is version 2.5
I think the GRAPHIC keyword simply controls what SQLGetTypeInfo() returns in its result set - which is the list of column types supported by the database.
The keyword I was trying to use is "DisableUnicode". I tried putting that in the db2cli.ini, and passing it as a keyword in SQLDriverConnect(). Neither made any difference. This keyword is described in the readme and does not appear in the GUI for ODBC driver setup.
I am going to try and find the v 7.1 ODBC and try that, based on the following from release.txt, even though it is specific to UNIX.
4.37 Merant Driver Manager and the DB2 UDB Version 7 ODBC Driver on UNIX
Incompatibilities have been encountered with Unicode support when the
Merant Driver Manager accesses DB2's ODBC driver on UNIX. These
incompatibilities result in Unicode being used by the Merant Driver Manager
regardless of whether the application has requested its use. This can lead
to problems with products such as the Data Warehouse Center, Information
Catalog Manager, and MQSI, which require the Merant Driver Manager to
support non-IBM data sources. You can use an alternate DB2 ODBC driver
library without Unicode support enabled until a permanent solution is
available. The affected versions of DB2 UDB include Version 7.1 with FixPak
2 or later, and Version 7.2 at any FixPak level.
An alternative DB2 ODBC driver library without Unicode support enabled was
shipped with DB2 Versions 7.1 and 7.2 for AIX, HP-UX, and Solaris Operating
Environment. To use this alternative library, you must create a copy of it,
giving the copy the original DB2 ODBC driver library's name.