faiques
asked on
Cant connect to remote database via MyODBC 3.51.20
Hi
I have MySQL ODBC 3.51.20 installed on a windows XP machine. I have a MYSQL database on a Linux server on the same network. When I try to Test the connection while setting up the DSN I get the following Error Message - [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0
If I connect to a MYSQL database on the Win XP box it works fine.
I have already updated the user with the % thing and I have tried to open port 3306 on the linux server which may be the issue. My WinXP install is version 2002 (no SP installed as this im just doing a proof of concept)
Thanks in advance!
I have MySQL ODBC 3.51.20 installed on a windows XP machine. I have a MYSQL database on a Linux server on the same network. When I try to Test the connection while setting up the DSN I get the following Error Message - [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0
If I connect to a MYSQL database on the Win XP box it works fine.
I have already updated the user with the % thing and I have tried to open port 3306 on the linux server which may be the issue. My WinXP install is version 2002 (no SP installed as this im just doing a proof of concept)
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Need a solution quickly!
ASKER
It was a firewall issue. But not on Linux, but rather with my VMWare server. I was using VMWare for my Linux server and forgot to open the port on it.
ASKER