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