MySQL Forums
Forum List  »  Connector/ODBC

Cannot open firstm but can second time
Posted by: Stefan Eriksson
Date: November 01, 2016 04:05AM

Hello!

My customer use the Connector/ODBC 5.3.6 for Windows x84.
https://dev.mysql.com/downloads/connector/odbc/
The ODBC is used to connect to a MySQL running on another machine.

The customer have configured an MySQL ODBC 5.3 Unicode Driver in Window's ODBC configuration tool at C:\Windows\SysWOW64\odbcad32.exe.
This window is displayed to configure the ODCB-connection: https://dev.mysql.com/doc/connector-odbc/en/images/myodbc-win-odbcadmin-adddsn-5-1.png

When the customer press the "Test" button the connection fails. But when pressed again the connection is successful and the possible databases/schemas can be shown in the configuration tool.


In my application where the ODBC-connection is used, the application crashes when trying to open the connection the first time. When trying to open again, the connection is established.

The exception which was thrown has this error message:
"ERROR [HY000] [MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on '10.205.210.65' (10060)"


In sequence this happens:

Open() // Fails with the above exception.
Open() // Works

My customer have verified the connection to the MySQL-server on the remote machine with the MySQL Workbench. There is no problems with any permissions or network. Everything works except for first time when the connection should be established.

What could be the problem?


Best regards,
/Steffe

Options: ReplyQuote


Subject
Written By
Posted
Cannot open firstm but can second time
November 01, 2016 04:05AM


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.