Easysoft Data Access

How do I generate a Windows ODBC trace?

Article:
00946
Last Reviewed:
2nd December 2013
Revision:
6
  1. Open the ODBC Data Source Administrator tool:
    • For Microsoft Windows 8, in the Windows desktop, point to the upper-right corner of the screen, move the mouse pointer down, choose Settings > Control Panel > ODBC Data Sources (64-bit).
    • For Microsoft Windows Vista and Windows 7, choose Start > Control Panel > Administrative Tools > Data Sources (ODBC).
    • For Microsoft Windows Server 2008 and Windows Server 2008 R2, choose Start > Administrative Tools > Data Sources (ODBC).
    • For Microsoft Windows 2000, Windows XP and Windows Server 2003, choose Start > Settings > Control Panel > Administrative Tools > Data Sources.
    • For Microsoft Windows NT, choose Start > Settings > Control Panel > Data Sources.

    64-bit Windows There is both a 64-bit and 32-bit version of the ODBC Data Source Administrator. The 64-bit version enables you to trace the ODBC API calls that are made by a 64-bit application. The 32-bit version enables you to trace the ODBC API calls that are made by a 32-bit application.

    The 64-bit version is located in Control Panel (see the previous step). To run the 32-bit version, in the Windows Run dialog box, type:

    %windir%\syswow64\odbcad32.exe

    On Windows 8, both the 32-bit and 64-bit ODBC Administrator are located in Control Panel under Administrative tools: ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit).

    If you are not sure which version to use, in ODBC Data Source Administrator, check that you can see your ODBC data source in the relevant DSN tab. If you cannot see your data source listed, run the other version of ODBC Data Source Administrator. If you are using a DSN-less connection and do not get a log file after completing the steps in this article, try enabling tracing in the other version of ODBC Data Source Administrator.

    For more information about ODBC on 64-bit Windows platforms, see our 64-bit ODBC article.

  2. Click the Tracing tab at the top of the ODBC Data Source Administrator.
  3. 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).
  4. Click Start Tracing Now to enable tracing.

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

  5. Click the Apply button followed by the OK button until you exit the ODBC Administrator.

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

  6. Repeat the steps to stop the tracing.
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)