Database Reference
In-Depth Information
Figure 11-6.
Windows ODBC tracing
You need to select the
Log File Path
to write the logs to. The
Custom Trace DLL
field should be pre-populated
with the Windows-defined tracing dll and need not be changed. By default, it is set to the file
C:\windows\system32\
odbctrac.dll
.
Once tracing is started, all subsequent ODBC function calls will be recorded in the log file in your local machine.
A sample ODBC log file entries look similar to the following snippet:
test 1c4-186c ENTER SQLAllocEnv
HENV * 0x500BC504
test 1c4-186c EXIT SQLAllocEnv with return code 0 SQL_SUCCESS)
HENV * 0x500BC504 ( 0x008B9788)
test 1c4-186c ENTER SQLAllocEnv
HENV * 0x500BC508
test 1c4-186c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x500BC508 ( 0x008B9808)
test 1c4-186c ENTER SQLSetEnvAttr
SQLHENV 0x008B9808
SQLINTEGER 201 <SQL_ATTR_CONNECTION_POOLING>
SQLPOINTER 0 <SQL_CP_OFF>
SQLINTEGER -6
