Skip to content

Instantly share code, notes, and snippets.

@cmb69

cmb69/ODBC trace

Created June 4, 2015 11:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cmb69/6f090511bd4349161539 to your computer and use it in GitHub Desktop.
Save cmb69/6f090511bd4349161539 to your computer and use it in GitHub Desktop.
Download ZIP
bug #69736
Raw
ODBC trace
php 69736 17e0-15f4 ENTER SQLSetEnvAttr
SQLHENV 0x00000000
SQLINTEGER 201 <SQL_ATTR_CONNECTION_POOLING>
SQLPOINTER 2 <SQL_CP_ONE_PER_HENV>
SQLINTEGER 0
php 69736 17e0-15f4 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x00000000
SQLINTEGER 201 <SQL_ATTR_CONNECTION_POOLING>
SQLPOINTER 2 <SQL_CP_ONE_PER_HENV>
SQLINTEGER 0
php 69736 17e0-15f4 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x028CD6D8
php 69736 17e0-15f4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x028CD6D8 ( 0x00F24340)
php 69736 17e0-15f4 ENTER SQLSetEnvAttr
SQLHENV 0x00F24340
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER 0
php 69736 17e0-15f4 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x00F24340
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER 0
php 69736 17e0-15f4 ENTER SQLSetEnvAttr
SQLHENV 0x00F24340
SQLINTEGER 202 <SQL_ATTR_CP_MATCH>
SQLPOINTER 0 <SQL_CP_STRICT_MATCH>
SQLINTEGER 0
php 69736 17e0-15f4 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x00F24340
SQLINTEGER 202 <SQL_ATTR_CP_MATCH>
SQLPOINTER 0 <SQL_CP_STRICT_MATCH>
SQLINTEGER 0
php 69736 17e0-15f4 ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F24340
SQLHANDLE * 0x028CD6DC
php 69736 17e0-15f4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F24340
SQLHANDLE * 0x028CD6DC ( 0x00F243B8)
php 69736 17e0-15f4 ENTER SQLSetConnectAttr
SQLHDBC 0x00F243B8
SQLINTEGER 102 <SQL_ATTR_AUTOCOMMIT>
SQLPOINTER 1 <SQL_AUTOCOMMIT_ON>
SQLINTEGER -6
php 69736 17e0-15f4 EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
SQLHDBC 0x00F243B8
SQLINTEGER 102 <SQL_ATTR_AUTOCOMMIT>
SQLPOINTER 1 <SQL_AUTOCOMMIT_ON>
SQLINTEGER -6
php 69736 17e0-15f4 ENTER SQLSetConnectAttr
SQLHDBC 0x00F243B8
SQLINTEGER 110 <SQL_ATTR_ODBC_CURSORS>
SQLPOINTER 0 <SQL_CUR_USE_IF_NEEDED>
SQLINTEGER -6
php 69736 17e0-15f4 EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
SQLHDBC 0x00F243B8
SQLINTEGER 110 <SQL_ATTR_ODBC_CURSORS>
SQLPOINTER 0 <SQL_CUR_USE_IF_NEEDED>
SQLINTEGER -6
php 69736 17e0-15f4 ENTER SQLConnectW
HDBC 0x00F243B8
WCHAR * 0x00F21D10 [ -3] "69736\ 0"
SWORD -3
WCHAR * 0x61A88B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x61A88B34 [ -3] "******\ 0"
SWORD -3
php 69736 17e0-15f4 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 0x00F243B8
WCHAR * 0x00F21D10 [ -3] "69736\ 0"
SWORD -3
WCHAR * 0x61A88B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x61A88B34 [ -3] "******\ 0"
SWORD -3
php 69736 17e0-15f4 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F243B8
SQLHANDLE * 0x028CD908
php 69736 17e0-15f4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F243B8
SQLHANDLE * 0x028CD908 ( 0x00F2EAB0)
php 69736 17e0-15f4 ENTER SQLPrepare
HSTMT 0x00F2EAB0
UCHAR * 0x02AC83DC [ -3] "select * from film where titel like "Batman"\ 0"
SDWORD -3
php 69736 17e0-15f4 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 0x00F2EAB0
UCHAR * 0x02AC83DC [ -3] "select * from film where titel like "Batman"\ 0"
SDWORD -3
php 69736 17e0-15f4 ENTER SQLExecute
HSTMT 0x00F2EAB0
php 69736 17e0-15f4 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 0x00F2EAB0
DIAG [07002] [Microsoft][ODBC Microsoft Access Driver] 1 Parameter wurden erwartet, aber es wurden zu wenig Parameter übergeben. (-3010)
php 69736 17e0-15f4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 1
SQLWCHAR * 0x00ABDEE0
SQLINTEGER * 0x028CDB1C
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 511
SQLSMALLINT * 0x00ABDF28
php 69736 17e0-15f4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 1
SQLWCHAR * 0x00ABDEE0 [ 5] "07002"
SQLINTEGER * 0x028CDB1C (-3010)
SQLWCHAR * 0x00F2EDD8 [ 115] "[Microsoft][ODBC Microsoft Access Driver] 1 Parameter wurden erwartet, aber es wurden zu wenig Parameter \ffbergeben."
SQLSMALLINT 511
SQLSMALLINT * 0x00ABDF28 (115)
php 69736 17e0-15f4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 2
SQLWCHAR * 0x00ABDEE0
SQLINTEGER * 0x00ABDF38
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 1023
SQLSMALLINT * 0x00ABDF28
php 69736 17e0-15f4 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 2
SQLWCHAR * 0x00ABDEE0
SQLINTEGER * 0x00ABDF38
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 1023
SQLSMALLINT * 0x00ABDF28
php 69736 17e0-15f4 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
php 69736 17e0-15f4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
php 69736 17e0-15f4 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F243B8
SQLHANDLE * 0x028CD908
php 69736 17e0-15f4 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F243B8
SQLHANDLE * 0x028CD908 ( 0x00F2EAB0)
php 69736 17e0-15f4 ENTER SQLPrepare
HSTMT 0x00F2EAB0
UCHAR * 0x02AC8434 [ -3] "select * from film where titel like ""Batman""\ 0"
SDWORD -3
php 69736 17e0-15f4 EXIT SQLPrepare with return code -1 (SQL_ERROR)
HSTMT 0x00F2EAB0
UCHAR * 0x02AC8434 [ -3] "select * from film where titel like ""Batman""\ 0"
SDWORD -3
DIAG [42000] [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator) in Abfrageausdruck 'titel like []Batman[]'. (-3100)
php 69736 17e0-15f4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 1
SQLWCHAR * 0x00ABDEC0
SQLINTEGER * 0x028CDB1C
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 511
SQLSMALLINT * 0x00ABDF08
php 69736 17e0-15f4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 1
SQLWCHAR * 0x00ABDEC0 [ 5] "42000"
SQLINTEGER * 0x028CDB1C (-3100)
SQLWCHAR * 0x00F2EDD8 [ 119] "[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator) in Abfrageausdruck 'titel like []Batman[]'."
SQLSMALLINT 511
SQLSMALLINT * 0x00ABDF08 (119)
php 69736 17e0-15f4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 2
SQLWCHAR * 0x00ABDEC0
SQLINTEGER * 0x00ABDF18
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 1023
SQLSMALLINT * 0x00ABDF08
php 69736 17e0-15f4 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
SQLSMALLINT 2
SQLWCHAR * 0x00ABDEC0
SQLINTEGER * 0x00ABDF18
SQLWCHAR * 0x00F2EDD8
SQLSMALLINT 1023
SQLSMALLINT * 0x00ABDF08
php 69736 17e0-15f4 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
php 69736 17e0-15f4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x00F2EAB0
php 69736 17e0-15f4 ENTER SQLEndTran
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F243B8
SQLSMALLINT 1
php 69736 17e0-15f4 EXIT SQLEndTran with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F243B8
SQLSMALLINT 1
php 69736 17e0-15f4 ENTER SQLDisconnect
HDBC 0x00F243B8
php 69736 17e0-15f4 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 0x00F243B8
php 69736 17e0-15f4 ENTER SQLFreeHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F243B8
php 69736 17e0-15f4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00F243B8
php 69736 17e0-15f4 ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00F24340
php 69736 17e0-15f4 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00F24340
Raw
test script
<?php
$conn = new PDO('odbc:69736', '', '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING]);
$result = $conn->query('select * from film where titel like "Batman"');
$result = $conn->query('select * from film where titel like ""Batman""');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment