1 message in com.mysql.lists.win32RE: SQL no longer connects ...additio...| From | Sent On | Attachments |
|---|---|---|
| Anne Gibson | 18 Dec 2003 09:06 |
| Subject: | RE: SQL no longer connects ...additional info-' log report' |
|---|---|
| From: | Anne Gibson (chey...@gncom.com) |
| Date: | 12/18/2003 09:06:55 AM |
| List: | com.mysql.lists.win32 |
I don't know it this sheds any light but I checked the log report from when I *believe* it connected and then subsequent attempts to connection which failed. It seems it tries-at first succeeds and then fails and it *seems* to be connected to the ODBC connection. This log includes all attempts both before and after reinstallation of previously mention programs. (too bad it doesn't log the times of the attempts.)
vssvc b1c-d60 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00000000 SQLHANDLE * 0x0110F8FC ( 0x005d1540)
vssvc b1c-d60 ENTER SQLSetEnvAttr SQLHENV 005D1540 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 0x00000003 SQLINTEGER 0
*this seems to be the beginning of the trouble*
vssvc b1c-d60 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 005D1540 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 0x00000003 (BADMEM) SQLINTEGER 0
vssvc b1c-d60 ENTER SQLSetEnvAttr SQLHENV 005D1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attribute 201] SQLINTEGER 0
vssvc b1c-d60 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 005D1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attribute 201] SQLINTEGER 0
vssvc b1c-d60 ENTER SQLAllocHandle SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 005D1540 SQLHANDLE * 0110F8F8
vssvc b1c-d60 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 005D1540 SQLHANDLE * 0x0110F8F8 ( 0x005d15e8)
vssvc b1c-d60 ENTER SQLSetConnectAttrW SQLHDBC 005D15E8 SQLINTEGER 1241 <unknown> SQLPOINTER [Unknown attribute 1241] SQLINTEGER -5
vssvc b1c-d60 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 005D15E8 SQLINTEGER 1241 <unknown> SQLPOINTER [Unknown attribute 1241] SQLINTEGER -5
vssvc b1c-d60 ENTER SQLSetConnectAttrW SQLHDBC 005D15E8 SQLINTEGER 1242 <unknown> SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3
vssvc b1c-d60 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 005D15E8 SQLINTEGER 1242 <unknown> SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3
vssvc b1c-d60 ENTER SQLBrowseConnectW HDBC 005D15E8 WCHAR * 0x00409EF0 [ -3] "***" SWORD -3 WCHAR * 0x00409EF0 SWORD 8 SWORD * 0x00000000
vssvc b1c-d60 EXIT SQLBrowseConnectW with return code 99 (SQL_NEED_DATA) HDBC 005D15E8 WCHAR * 0x00409EF0 [ -3] "***" SWORD -3 WCHAR * 0x00409EF0 SWORD 8 SWORD * 0x00000000
vssvc b1c-d60 ENTER SQLDisconnect HDBC 005D15E8
vssvc b1c-d60 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 005D15E8
vssvc b1c-d60 ENTER SQLFreeHandle SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 005D15E8
vssvc b1c-d60 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 005D15E8
vssvc b1c-d60 ENTER SQLFreeHandle SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 005D1540
vssvc b1c-d60 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 005D1540
I don't know if this helps, Anne Toronto