KB483749: Enable ODBC Tracing with a Timestamp for MicroStrategy using Windows Platforms

In a Windows platform, ODBC tracing is not included with a timestamp. However, you can enable it.

How to Enable ODBC Tracing with a Timestamp

• Download the mytrc64.zip file attached to this article.
• Extract the file into the directory C:/Windows/System32.
• open the Registry Editor and navigate to

  HKEY-LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC.

• Create a new string called TraceOptions and set its value to 1.
• Open ODBC Administrator (64 bit) and select the Tracing tab.
• Set Log File Path to a location with SQL.LOG as the file name.
• Set Custom Trace DLL to C:\WINDOWS\system32\mytrc64.dll. (Please use branded trace file "mytrc64.dll", otherwise it might cause child process crash)
• Click Start Tracing Now.

• Perform the action required to be diagnosed via the ODBC trace then click Stop Tracing Now.

In the path specified in the Log File Path field, two files will appear: SQLINFO.LOG and SQL01.LOG.
SQLINFO.LOG contains information regarding the driver used, the database executed against, and some other diagnostic information.
SQL01.LOG contains the ODBC functions executed with a timestamp denoted when each function was executed.