Running ODBC 5.2 (10.0.0.10) and MySQL 4.x (10.0.0.50). Yes, I know that ODBC 5.x dosen't officaly support MySQL 4.x but it was working fine for ~8 months till now when we have little problems with ISP and external network is not that stable.
Thing is that ODBC can make connection with MySQL fine when external network is working but in a moment when we get problem with external network the connection between 10.0.0.10 (ODBC) and 10.0.0.50 (MySQL) stops.
OLE DB provider "MSDASQL" for linked server "xyz" returned message\ "[MySQL][ODBC 5.2(w) Driver]Lost connection to MySQL server at\ 'waiting for initial communication packet', system error: 10060". Cannot initialize the data source object of OLE DB "MSDASQL" for linked server "xyz".
... and it gets even more interesting I can successfully
ping between ODBC and MySQL machines and even make
telnet for 3306 from 10.0.0.10 to 10.0.0.50 while external network dosen't work and ODBC connection fails.
This leads to my question... why ODBC can't make connection to MySQL without external network? Have I missed something or should I downgrade to ODBC 3.51?