Sample ODBC Driver Manager Trace output

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.

PB110 179:192   EXIT  SQLSetConnectOption  with return code 0 (SQL_SUCCESS)
      HDBC 0x036e1300
      UWORD    104 <SQL_OPT_TRACE>
      UDWORD 1

PB110 179:192   ENTER SQLSetConnectOption 
   HDBC 0x036e1300
   UWORD 110 <SQL_OPT_TRACEFILE>
   UDWORD 160694373
PB110 179:192   EXIT  SQLSetConnectOption  with return code 0 (SQL_SUCCESS)
   HDBC 0x036e1300
   UWORD 110 <SQL_OPT_TRACEFILE>
   UDWORD 160694373
PB110 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>
PB110 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>
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 6 <SQL_DRIVER_NAME>
      PTR 0x036e2098 
      SWORD 6 
      SWORD * 0x0012cd30
PB110 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 [01104] [Sybase][ODBC Driver]Data truncated (0) 
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 10 <SQL_ODBC_VER>
      PTR 0x036e39f8 
      SWORD 100 
      SWORD * 0x0012cd38
PB110 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)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 2 <SQL_DATA_SOURCE_NAME>
      PTR 0x036e3c88 
      SWORD 512 
      SWORD * 0x0012cc32
PB110 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)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 16 <SQL_DATABASE_NAME>
      PTR 0x036e3c88 
      SWORD 512 
      SWORD * 0x0012cc32
PB110 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)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>
      PTR 0x036e3c88 
      SWORD 512 
      SWORD * 0x0012cc32
PB110 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)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 13 <SQL_SERVER_NAME>
      PTR 0x036e3c88 
      SWORD 512 
      SWORD * 0x0012cc32
PB110 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)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 17 <SQL_DBMS_NAME>
      PTR 0x036e3c88 
      SWORD 512 
      SWORD * 0x0012cab6
PB110 179:192   EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
      HDBC 0x036e1300
      UWORD 17 <SQL_DBMS_NAME>
      PTR 0x036e3c88 [  48] "SQL Anywhere"
      SWORD 512 
      SWORD * 0x0012cab6 (48)
PB110 179:192   ENTER SQLGetInfoW 
      HDBC 0x036e1300
      UWORD 6 <SQL_DRIVER_NAME>
      PTR 0x036e1a10 
      SWORD 550 
      SWORD * 0x0012cbbc
PB110 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)
PB110 179:192   ENTER SQLAllocStmt 
      HDBC 0x036e1300
      HSTMT * 0x0012d0b4 
PB110 179:192   EXIT  SQLAllocStmt  with return code 0 (SQL_SUCCESS)
      HDBC 0x036e1300
      HSTMT * 0x0012d0b4 ( 0x036e1c48)
PB110 179:192   ENTER SQLGetTypeInfo 
      HSTMT 0x036e1c48
      SWORD 0 <SQL_ALL_TYPES>