odbc driver trace on windows.

Connectivity
Enthusiast

odbc driver trace on windows.

Dears,

I could enable the driver trace on Linux. (modify the odbc.ini file.)

But for windows, do we have the same functionality? I did not see it. Enable DSN Tracing is not the option in windows.

I need to see SQL and function calls to the driver from application. Any idea?

Thanks,

Ricky

2 REPLIES
Teradata Employee

Re: odbc driver trace on windows.

The "Windows ODBC Driver Manager" trace feature will capture the Application-to-ODBC-Driver Function calls and the SQL.

Refer to MSDN articles; for example http://support.microsoft.com/kb/274551 and http://msdn.microsoft.com/en-us/library/ms711020(v=vs.85).aspx.

You do not need the Driver-Tracing (vs. ODBC Driver Manager tracing) feature in order to capture the SQL and the ODBC function calls.

Enthusiast

Re: odbc driver trace on windows.

Hi ricky_ru,

To start capturing an ODBC driver manager trace on Windows, first go into the ODBC Administrator, Tracing tab. Under the Log File Path, enter the path and file name you wish for your log. Click on Apply, then click on Start Tracing Now.

Regards.