windows - How to get the ODBC name from this trace logs that an application is using to connect -
how odbc name trace logs application using connect (in case: firebird database)
autoreps 1f8c-140c enter sqlallocenv henv * 0x5d67b1ac autoreps 1f8c-140c exit sqlallocenv return code 0 (sql_success) henv * 0x5d67b1ac ( 0x02e61078) autoreps 1f8c-140c enter sqlgetenvattr sqlhenv 0x02e61078 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0x0012ea64 sqlinteger 4 sqlinteger * 0x0012ea60 autoreps 1f8c-140c exit sqlgetenvattr return code 0 (sql_success) sqlhenv 0x02e61078 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0x0012ea64 (0) <sql_cp_off> sqlinteger 4 sqlinteger * 0x0012ea60 (0) autoreps 1f8c-140c enter sqlallocenv henv * 0x5d67b1b0 autoreps 1f8c-140c exit sqlallocenv return code 0 (sql_success) henv * 0x5d67b1b0 ( 0x02e610f0) autoreps 1f8c-140c enter sqlsetenvattr sqlhenv 0x02e610f0 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0 <sql_cp_off> sqlinteger -6 autoreps 1f8c-140c exit sqlsetenvattr return code 0 (sql_success) sqlhenv 0x02e610f0 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0 <sql_cp_off> sqlinteger -6 autoreps 1f8c-140c enter sqlallocconnect henv 0x02e610f0 hdbc * 0x0012f6f0 autoreps 1f8c-140c exit sqlallocconnect return code 0 (sql_success) henv 0x02e610f0 hdbc * 0x0012f6f0 ( 0x02e61388) autoreps 1f8c-140c enter sqlgetinfow hdbc 0x02e61388 uword 10 <sql_odbc_ver> ptr 0x0012f6c0 sword 22 sword * 0x00000000 autoreps 1f8c-140c exit sqlgetinfow return code 0 (sql_success) hdbc 0x02e61388 uword 10 <sql_odbc_ver> ptr 0x0012f6c0 [ -3] "03.80.0000\ 0" sword 22 sword * 0x00000000 autoreps 1f8c-140c enter sqlsetconnectattrw sqlhdbc 0x02e61388 sqlinteger 103 <sql_attr_login_timeout> sqlpointer 15 sqlinteger -6 autoreps 1f8c-140c exit sqlsetconnectattrw return code 0 (sql_success) sqlhdbc 0x02e61388 sqlinteger 103 <sql_attr_login_timeout> sqlpointer 15 sqlinteger -6 autoreps 1f8c-140c enter sqldriverconnectw hdbc 0x02e61388 hwnd 0x00000000 wchar * 0x6d5f8b34 [ -3] "******\ 0" sword -3 wchar * 0x6d5f8b34 sword -3 sword * 0x00000000 uword 0 <sql_driver_noprompt> autoreps 1f8c-140c exit sqldriverconnectw return code -1 (sql_error) hdbc 0x02e61388 hwnd 0x00000000 wchar * 0x6d5f8b34 [ -3] "******\ 0" sword -3 wchar * 0x6d5f8b34 sword -3 sword * 0x00000000 uword 0 <sql_driver_noprompt> diag [im002] [microsoft][odbc driver manager] data source name not found , no default driver specified (0) autoreps 1f8c-140c enter sqlgetdiagrecw sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x02e61388 sqlsmallint 1 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1f8c-140c exit sqlgetdiagrecw return code 0 (sql_success) sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x02e61388 sqlsmallint 1 sqlwchar * 0x0012f654 [ 5] "im002" sqlinteger * 0x0012f22c (0) sqlwchar * 0x0012f254 [ 91] "[microsoft][odbc driver manager] data source name not found , no default driver specified" sqlsmallint 512 sqlsmallint * 0x0012f23c (91) autoreps 1f8c-140c enter sqlgetdiagrecw sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x02e61388 sqlsmallint 2 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1f8c-140c exit sqlgetdiagrecw return code 100 (sql_no_data_found) sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x02e61388 sqlsmallint 2 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1f8c-140c enter sqlfreeconnect hdbc 0x02e61388 autoreps 1f8c-140c exit sqlfreeconnect return code 0 (sql_success) hdbc 0x02e61388 autoreps 1f8c-140c enter sqlfreeenv henv 0x02e61078 autoreps 1f8c-140c exit sqlfreeenv return code 0 (sql_success) henv 0x02e61078 autoreps 1f8c-140c enter sqlfreeenv henv 0x02e610f0 autoreps 1f8c-140c exit sqlfreeenv return code 0 (sql_success) henv 0x02e610f0 autoreps 1214-5e8 enter sqlallocenv henv * 0x5d67b1ac autoreps 1214-5e8 exit sqlallocenv return code 0 (sql_success) henv * 0x5d67b1ac ( 0x02e61e60) autoreps 1214-5e8 enter sqlgetenvattr sqlhenv 0x02e61e60 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0x0012ea64 sqlinteger 4 sqlinteger * 0x0012ea60 autoreps 1214-5e8 exit sqlgetenvattr return code 0 (sql_success) sqlhenv 0x02e61e60 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0x0012ea64 (0) <sql_cp_off> sqlinteger 4 sqlinteger * 0x0012ea60 (0) autoreps 1214-5e8 enter sqlallocenv henv * 0x5d67b1b0 autoreps 1214-5e8 exit sqlallocenv return code 0 (sql_success) henv * 0x5d67b1b0 ( 0x02e61ed8) autoreps 1214-5e8 enter sqlsetenvattr sqlhenv 0x02e61ed8 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0 <sql_cp_off> sqlinteger -6 autoreps 1214-5e8 exit sqlsetenvattr return code 0 (sql_success) sqlhenv 0x02e61ed8 sqlinteger 201 <sql_attr_connection_pooling> sqlpointer 0 <sql_cp_off> sqlinteger -6 autoreps 1214-5e8 enter sqlallocconnect henv 0x02e61ed8 hdbc * 0x0012f6f0 autoreps 1214-5e8 exit sqlallocconnect return code 0 (sql_success) henv 0x02e61ed8 hdbc * 0x0012f6f0 ( 0x002493f0) autoreps 1214-5e8 enter sqlgetinfow hdbc 0x002493f0 uword 10 <sql_odbc_ver> ptr 0x0012f6c0 sword 22 sword * 0x00000000 autoreps 1214-5e8 exit sqlgetinfow return code 0 (sql_success) hdbc 0x002493f0 uword 10 <sql_odbc_ver> ptr 0x0012f6c0 [ -3] "03.80.0000\ 0" sword 22 sword * 0x00000000 autoreps 1214-5e8 enter sqlsetconnectattrw sqlhdbc 0x002493f0 sqlinteger 103 <sql_attr_login_timeout> sqlpointer 15 sqlinteger -6 autoreps 1214-5e8 exit sqlsetconnectattrw return code 0 (sql_success) sqlhdbc 0x002493f0 sqlinteger 103 <sql_attr_login_timeout> sqlpointer 15 sqlinteger -6 autoreps 1214-5e8 enter sqldriverconnectw hdbc 0x002493f0 hwnd 0x00000000 wchar * 0x6d5f8b34 [ -3] "******\ 0" sword -3 wchar * 0x6d5f8b34 sword -3 sword * 0x00000000 uword 0 <sql_driver_noprompt> autoreps 1214-5e8 exit sqldriverconnectw return code -1 (sql_error) hdbc 0x002493f0 hwnd 0x00000000 wchar * 0x6d5f8b34 [ -3] "******\ 0" sword -3 wchar * 0x6d5f8b34 sword -3 sword * 0x00000000 uword 0 <sql_driver_noprompt> diag [im002] [microsoft][odbc driver manager] data source name not found , no default driver specified (0) autoreps 1214-5e8 enter sqlgetdiagrecw sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x002493f0 sqlsmallint 1 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1214-5e8 exit sqlgetdiagrecw return code 0 (sql_success) sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x002493f0 sqlsmallint 1 sqlwchar * 0x0012f654 [ 5] "im002" sqlinteger * 0x0012f22c (0) sqlwchar * 0x0012f254 [ 91] "[microsoft][odbc driver manager] data source name not found , no default driver specified" sqlsmallint 512 sqlsmallint * 0x0012f23c (91) autoreps 1214-5e8 enter sqlgetdiagrecw sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x002493f0 sqlsmallint 2 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1214-5e8 exit sqlgetdiagrecw return code 100 (sql_no_data_found) sqlsmallint 2 <sql_handle_dbc> sqlhandle 0x002493f0 sqlsmallint 2 sqlwchar * 0x0012f654 sqlinteger * 0x0012f22c sqlwchar * 0x0012f254 sqlsmallint 512 sqlsmallint * 0x0012f23c autoreps 1214-5e8 enter sqlfreeconnect hdbc 0x002493f0 autoreps 1214-5e8 exit sqlfreeconnect return code 0 (sql_success) hdbc 0x002493f0 autoreps 1214-5e8 enter sqlfreeenv henv 0x02e61e60 autoreps 1214-5e8 exit sqlfreeenv return code 0 (sql_success) henv 0x02e61e60 autoreps 1214-5e8 enter sqlfreeenv henv 0x02e61ed8 autoreps 1214-5e8 exit sqlfreeenv return code 0 (sql_success) henv 0x02e61ed8
not sure mean "odbc name"... mean target database user-name? however, sqldriverconnect[w] has following syntax:
sqlreturn sqldriverconnect( sqlhdbc connectionhandle, sqlhwnd windowhandle, sqlchar * inconnectionstring, sqlsmallint stringlength1, sqlchar * outconnectionstring, sqlsmallint bufferlength, sqlsmallint * stringlength2ptr, sqlusmallint drivercompletion); by reading trace looks "inconnectionstring" ""******\ 0". they're trying mask because connection string includes password. length of inconnectionstring (subsequent field) -3 means: null terminated.
the error says connection string contains wrong dsn
Comments
Post a Comment