MySQL Forums
Forum List  »  Connector/ODBC

fail to reconnect to mysql8
Posted by: Sami Kamber
Date: June 27, 2024 06:20AM

I am getting this error below after attempting to reconnect to MySql8 using odbc version 8.036 in windows 10 with 32bit.

I does work for first time but after trying to reconnect again I get this error below. Then after waiting 2 minutes and try again it work again
but trying again immediatly will fail.

I don't have connection issue from mac system using MySql Workbench8


MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'xxxxxxx.rds.amazonaws.com:3306' (10060)"


odbcad32 214-1a70 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x07311BA0
SQLSMALLINT 1
SQLWCHAR * 0x02AB9C04
SQLINTEGER * 0x02AB9EB3
SQLWCHAR * 0x03F5EB58
SQLSMALLINT 511
SQLSMALLINT * 0x02AB9C50

odbcad32 214-1a70 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x07311BA0
SQLSMALLINT 1
SQLWCHAR * 0x02AB9C04 [ 5] "HY000"
SQLINTEGER * 0x02AB9EB3 (2003)
SQLWCHAR * 0x03F5EB58 [ 141] "[MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'xxxxxxxxx.rds.amazonaws.com:3306' (10060)"
SQLSMALLINT 511
SQLSMALLINT * 0x02AB9C50 (141)

odbcad32 214-1a70 ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x07310728

odbcad32 214-1a70 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x07310728

DIAG [HY010] [Microsoft][ODBC Driver Manager] Function sequence error (0)

Options: ReplyQuote


Subject
Written By
Posted
fail to reconnect to mysql8
June 27, 2024 06:20AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.