ODBC

What version of the ODBC specification do your drivers support?

The Connect for ODBC drivers support version 3.52 of the ODBC specification.

What databases and platforms are supported?

See the latest support matrix for Connect for ODBC.

When I attempt to connect I get "Specified driver could not be loaded due to system error 126 or 1157".

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

When attempting to connect or execute SQL with a Connect for ODBC driver, the error "You are not licensed to use this driver under the license you have purchased" is returned.

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.

What are DB2 packages and why do I have to bind them with the DB2 Connect for ODBC driver?

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.

How do I know whether to use Connect for ODBC or Connect64 for ODBC?

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.

Can your Connect for ODBC (32-bit) drivers run on a 64-bit operating system?

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.

Do your Connect for ODBC drivers support Unicode?

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.

I am having trouble using Ref Cursor parameters with the Oracle Connect for ODBC driver. What do I do?

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.

What is the difference between the "latest build" and a Service Pack?

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.