Enabling Logging for ODBC on Windows

On Windows, to enable logging for an ODBC data source, you generally use the ODBC Data Source Administrator screen (within the Windows Control Panel). To access this screen, open the Windows Control Panel, open the Administrative Tools subpanel, and then double-click Data Sources (ODBC). Or open the Windows Control Panel and then double-click ODBC Data Sources.

Then do the following:

To enable logging for the client driver, find the definition of the DSN that you want to log. Different kinds of DSN are on different tabs. Click the appropriate tab. Look for a check box labeled ODBC Log (or Log or variations) and select it.
To enable logging for the driver manager, click the Tracing tab and then click the Start Tracing Now button.
The Log File Path field determines the location of the trace file.

The details may vary depending on your version of Windows as well as the client driver that you use for this DSN.

Note:

The default location of the CacheODBC.log file varies depending on the version of Windows. For Windows Vista and higher, the log will be created in the Public folder under %PUBLIC%\Logs (default path C:\Users\Public\Logs). This folder is accessible by all users and allows just one location for the log to be created. For earlier versions, the log is under %WINDIR% (the C:\Windows or C:\WinNT folder, depending on your version of Windows).

You can change the name and location of the log file by setting the CACHEODBCTRACEFILE environment variable (see “InterSystems ODBC Environment Variables” later in this chapter).