Interoperability Issues

Interoperability issues can occur with a working ODBC application in any of the following ODBC components: ODBC application, ODBC driver, ODBC Driver Manager, and/or data source. Refer to “What Is ODBC?” in Chapter 2 of the DataDirect Connect Series for ODBC User’s Guide for more information about ODBC components.

For example, any of the following problems may occur because of an interoperability issue:

■	SQL statements may fail to execute.

■	Data may be returned/updated/deleted/inserted incorrectly.

■	A hang or core dump may occur.

Troubleshooting the Issue

Isolate the component in which the issue is occurring. Is it an ODBC application, an ODBC driver, an ODBC Driver Manager, or a data source issue?

To troubleshoot the issue:

1	Test to see if your ODBC application is the source of the problem. To do this, replace your working ODBC application with a more simple application. If you can reproduce the issue, you know your ODBC application is not the cause.

On Windows, you can use ODBC Test, which is part of the Microsoft ODBC SDK, or the Example application that is shipped with the DataDirect Connect Series for ODBC drivers. See “ODBC Test” and “The Example Application” for details.

On UNIX and Linux, you can use the Example application that is shipped with the DataDirect Connect Series for ODBC drivers. See “The Example Application” for details.

2	Test to see if the data source is the source of the problem. To do this, use the native database tools that are provided by your database vendor.

3	If neither the ODBC application nor the data source is the source of your problem, troubleshoot the ODBC driver and the ODBC Driver Manager.

In this case, we recommend that you create an ODBC trace log to provide to Customer Support. See “ODBC Trace” for details.