How do I generate a Windows ODBC trace?

    • Do one of the following:

      If your application is 64-bit, in the Windows Run dialog box, enter:

      odbcad32.exe

      –Or–

    • If your application is 32-bit, in the Windows Run dialog box, enter:

      %windir%\syswow64\odbcad32.exe
  1. Click the Tracing tab at the top of the ODBC Data Source Administrator.
  2. You can specify the name of the log file in the Log File Path text box along with the full path (for example: C:\logs\ODBC.log).
  3. Click Start Tracing Now to enable tracing.

    Now you will notice that the button has now changed to Stop Tracing Now

  4. Click the Apply button followed by the OK button until you exit the ODBC Data Source Administrator.

    All ODBC calls will now be logged to the specified log file.

  5. Repeat the steps to stop the tracing.