Enabling ODBC API Tracing

On Windows, enable tracing by clicking Start Tracing Now on the Tracing tab of the ODBC Data Source Administrator. Click Stop Tracing Now to disable tracing. Tracing continues until you disable it. Be sure to turn off tracing by clicking the Stop Tracing Now button when you are finished reproducing the issue because tracing decreases the performance of your ODBC application.

To specify the path and name of the trace log file, type the path and name in the Log File Path field or click Browse to select a log file. If no location is specified, the trace log resides in the working directory of the application you are using.

The default DLL, odbctrac.dll, performs tracing. If you want to use a custom DLL instead, type the path and name of the DLL in the Custom Trace DLL field or click Browse to select a DLL.

After making these changes on the Trace tab, click Apply for them to take effect.

On UNIX and Linux, you can enable tracing by modifying the [ODBC] section in the system information file (the odbc.ini file). The [ODBC] section of the system information file includes three keywords related to tracing: Trace, TraceFile, and TraceDll. For example:

In this example, tracing is enabled, trace information is logged in a file named odbctrace.out, and odbctrac.so performs the tracing.

You enable tracing by setting the value of Trace to 1. Set the value to 0 to disable tracing. Tracing continues until you disable it. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application.

To specify the path and name of the trace log file, enter it as the value for TraceFile. If no location is specified, the trace log resides in the working directory of the application you are using.

OpenAccess SDK ships a default shared object to perform tracing: ivtrc27.so (32-bit) or ddtrc27.so (64-bit). To use a custom shared object instead, enter the path and name of the shared object as the value for TraceDll.