This section shows a partial example of output from ODBC Driver Manager Trace to give you an idea of the information it provides. The example is part of the trace on an ODBC connection to the EAS Demo DB.
For more about a particular ODBC API call, see your ODBC documentation.
PB105 179:192 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 104 <SQL_OPT_TRACE> UDWORD 1 PB105 179:192 ENTER SQLSetConnectOption HDBC 0x036e1300 UWORD 105 <SQL_OPT_TRACEFILE> UDWORD 160694373 PB105 179:192 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 105 <SQL_OPT_TRACEFILE> UDWORD 160694373 PB105 179:192 ENTER SQLDriverConnectW HDBC 0x036e1300 HWND 0x004607fa WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1f4be068 SWORD 8 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> PB105 179:192 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 HWND 0x004607fa WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1f4be068 SWORD 8 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 6 <SQL_DRIVER_NAME> PTR 0x036e2098 SWORD 6 SWORD * 0x0012cd30 PB105 179:192 EXIT SQLGetInfoW with return code 1 (SQL_SUCCESS_WITH_INFO) HDBC 0x036e1300 UWORD 6 <SQL_DRIVER_NAME> PTR 0x036e2098 [ 6] "DB\ 0" SWORD 6 SWORD * 0x0012cd30 (22) DIAG [01054] [Sybase][ODBC Driver]Data truncated (0) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 10 <SQL_ODBC_VER> PTR 0x036e39f8 SWORD 100 SWORD * 0x0012cd38 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 10 <SQL_ODBC_VER> PTR 0x036e39f8 [ 20] "03.51.0000" SWORD 100 SWORD * 0x0012cd38 (20) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x036e3c88 SWORD 512 SWORD * 0x0012cc32 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x036e3c88 [ 28] "EAS Demo DB" SWORD 512 SWORD * 0x0012cc32 (28) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 16 <SQL_DATABASE_NAME> PTR 0x036e3c88 SWORD 512 SWORD * 0x0012cc32 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 16 <SQL_DATABASE_NAME> PTR 0x036e3c88 [ 16] "easdemodb" SWORD 512 SWORD * 0x0012cc32 (16) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x036e3c88 SWORD 512 SWORD * 0x0012cc32 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x036e3c88 [ 2] "N" SWORD 512 SWORD * 0x0012cc32 (2) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 13 <SQL_SERVER_NAME> PTR 0x036e3c88 SWORD 512 SWORD * 0x0012cc32 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 13 <SQL_SERVER_NAME> PTR 0x036e3c88 [ 16] "easdemodb" SWORD 512 SWORD * 0x0012cc32 (16) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 17 <SQL_DBMS_NAME> PTR 0x036e3c88 SWORD 512 SWORD * 0x0012cab6 PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 17 <SQL_DBMS_NAME> PTR 0x036e3c88 [ 48] "Adaptive Server Anywhere" SWORD 512 SWORD * 0x0012cab6 (48) PB105 179:192 ENTER SQLGetInfoW HDBC 0x036e1300 UWORD 6 <SQL_DRIVER_NAME> PTR 0x036e1a10 SWORD 550 SWORD * 0x0012cbbc PB105 179:192 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 UWORD 6 <SQL_DRIVER_NAME> PTR 0x036e1a10 [ 22] "DBODBC9.DLL" SWORD 550 SWORD * 0x0012cbbc (22) PB105 179:192 ENTER SQLAllocStmt HDBC 0x036e1300 HSTMT * 0x0012d0b4 PB105 179:192 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 0x036e1300 HSTMT * 0x0012d0b4 ( 0x036e1c48) PB105 179:192 ENTER SQLGetTypeInfo HSTMT 0x036e1c48 SWORD 0 <SQL_ALL_TYPES>
