3305 Main Street Ste 019 Vancouver, WA 98663

How To Use ODBC Tracing

This article describes how to enable ODBC tracing. This process may be recommended by a technical support representative for the purpose of diagnosing problems.

  1. Enable Tracing
    1. Start ODBC Data Source Administrator - To do this run ODBCAD32.EXE. With 32-bit operating systems, this executable will be found under C:\Windows\System32\. With 64-bit operating systems, this file will be found under C:\Windows\SysWow64\. Running this executable normally requires elevated permission.
    2. Click the Tracing tab
    3. In the Log File Path box, click Browse and choose a location and name for the log file.
    4. Click Start Tracing Now
    5. Click OK to close ODBC Data Source Administrator
  2. Perform database tasks - This would include the steps you are taking that are resulting in the problem being diagnosed and may include operations such as connecting to a database, executing queries (reports), or updating information.
  3. Disable Tracing
    1. Start ODBC Data Source Administrator - To do this run ODBCAD32.EXE. With 32-bit operating systems, this executable will be found under C:\Windows\System32\. With 64-bit operating systems, this file will be found under C:\Windows\SysWow64\. Running this executable normally requires elevated permission.
    2. Click the Tracing tab
    3. Click Stop Tracing Now
    4. Click OK to close ODBC Data Source Administrator
  4. Send the trace log to your support representative - The path and name of the log file was identified in step 1.3.