The Connect for ODBC drivers support version 3.52 of the ODBC specification.
See the latest support matrix for Connect for ODBC.
This error is returned when the driver DLL or a DLL it relies on, such as database client software cannot be found. See additional details in Knowledgebase document 000023322 regarding this error
This error occurs when the driver is not properly licensed. Typically, you will see this error when using a copy of the driver that has been locked for OEM use with a particular application. See complete details in Knowledgebase document 000002174 regarding this error.
DB2 packages are database objects that allow an application to issue dynamic SQL. Any DB2 application (ODBC or otherwise) that wishes to issue dynamic SQL will have to use one or more DB2 packages. If you are getting an error message when attempting to Bind packages, please search our Knowledgebase for the error.
If your application was built with 32-bit system libraries, you must use Connect for ODBC. If your application was built with 64-bit system libraries, you must use Connect64 for ODBC.
It is important to remember that the only factor to consider in this decision is the application that will be using the ODBC driver. It does not matter if the database you are connecting to is 32-bit or 64-bit enabled.
Our 32-bit Connect for ODBC drivers can run on a 64-bit OS provided 32-bit system libraries are available, and that the drivers are used with a 32-bit application.
Most of our Connect for ODBC drivers support both reading/writing Unicode data from the database, as well as the ODBC 'W' (SQLConnectW, SQLTablesW, etc) functions. See the "Unicode" section for each driver in the Connect for ODBC Reference Guide for more information.
Because ODBC does not define a "Ref Cursor" or "Cursor" type the Connect for ODBC driver handles Oracle Ref Cursors behind the scenes. See the section in the Connect for ODBC Reference Guide on Ref Cursors for more information.
The latest build is the most recent patch available for a driver which includes all previous fixes. A service pack is specific roll-up build that we label and post to our external web site as a Service Pack. It includes all latest build drivers at the time of the Service Pack release.