Workbench connects remotely but cannot connect from same PC with MySQL ODBC 5.1 Driver
Posted by:
Dan E
Date: August 21, 2014 08:36PM
This has worked previously for over a year. Now, my VB app cannot connect to the remote MySQL DB.
To troubleshoot, I installed MySQL Workbench. It connects remotely fine. I can query, etc all as normal. I believe this confirms all firewall, routing, IP, port, security, authority and such issues are NOT the problem. Am I right?
My application, however, fails with the call to cnMySQL.OPEN() with this error msg:
[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '##.##.##.##' (10060)
Next, I ran an ODBC trace. Everything in the trace works with the exceptions below:
TubsVB 1454-2534 ENTER SQLDriverConnectW
HDBC 0x00769CF8
HWND 0x00000000
WCHAR * 0x71DB8B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x71DB8B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
TubsVB 1454-2534 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x00769CF8
HWND 0x00000000
WCHAR * 0x71DB8B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x71DB8B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [S1000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '##.##.##.##' (10060) (2003)
TubsVB 1454-2534 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00769CF8
SQLSMALLINT 1
SQLWCHAR * 0x0018EF68
SQLINTEGER * 0x0018EB40
SQLWCHAR * 0x0018EB68
SQLSMALLINT 512
SQLSMALLINT * 0x0018EB50
TubsVB 1454-2534 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x00769CF8
SQLSMALLINT 1
SQLWCHAR * 0x0018EF68 [ 5] "S1000"
SQLINTEGER * 0x0018EB40 (2003)
SQLWCHAR * 0x0018EB68 [ 80] "[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '##.##.##.##' (10060)"
SQLSMALLINT 512
SQLSMALLINT * 0x0018EB50 (80)
The MySQL workbench does not use the ODBC driver so I cannot compare it's connection through the ODBC trace log ;-(
Obviously, I would love a solution, but if not that, how to proceed with tracing/problem isolation so I can figure it out?
Thanks to all for any tips, suggestions or solutions.
DE
Subject
Written By
Posted
Workbench connects remotely but cannot connect from same PC with MySQL ODBC 5.1 Driver
August 21, 2014 08:36PM
Sorry, you can't reply to this topic. It has been closed.
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.