ODBC trace

You can use various methods to trace for ODBC activity, depending on the operating system that you are using.

Starting trace

About this task

To start trace on Windows, complete step 1 or step 2 depending on your database. To start trace on Linux® or UNIX, complete step 3:

Procedure

  1. To trace ODBC interactions with an Oracle, PostgreSQL, or Sybase database, complete the following steps:
    1. Copy the uktrc95.dll and ukicu.dll binaries from your <ACE_INSTALL_DIR>\bin directory to the C:\Windows\System32 directory.
    2. On the Windows Start page, type “ODBC Administrator” to start the “ODBC Data Source Administrator (64-bit)” application.
    3. Click the Tracing tab.
    4. Click the Select DLL button.
    5. Select the C:\Windows\System32\uktrc95.dll.
    6. Click the Apply button.
    7. Optionally set a Log File Path to specify where the ODBC trace logs are written to.
    8. Click the Windows button.
    9. Select Machine-Wide tracing for all user identities.
    10. Click Start Tracing Now.
  2. To trace ODBC interactions with all other database types, complete the following steps:
    1. On the Start page, type “ODBC Administrator” to start the “ODBC Data Source Administrator (64-bit)” application.
    2. Click the Tracing tab.
    3. Optionally set a Log File Path to specify where the ODBC trace logs are written to and click the Apply button.
    4. Select Machine-Wide tracing for all user identities.
    5. Click Start Tracing Now.
    6. Click OK.
  3. To start ODBC tracing on Linux or UNIX, edit the [ODBC] stanza in the odbcinst.ini file in the directory pointed to by your ODBCSYSINI environment variable as follows:
    1. Change Trace=no to Trace=yes.
    2. Specify a path and file name for TraceFile.
    3. Make sure that the TraceFile entry points to a file system that has enough space to receive the trace output.
    4. Save the file.

Stopping trace

About this task

To stop trace on Windows, complete step 1. To stop trace on Linux or UNIX, complete step 2.

Procedure

  1. To stop trace on Windows, complete the following steps:
    1. On the Start page, type “ODBC Administrator” to start the “ODBC Data Source Administrator (64-bit)” application.
    2. Click the Tracing tab.
    3. Click Stop tracing now .
    4. Click OK .
  2. To stop tracing on Linux or UNIX, edit the [ODBC] stanza in the odbcinst.ini file in the directory pointed to by your ODBCSYSINI environment variable as follows:
    1. Change Trace=yes to Trace=no.
    2. Save the file.