Link to home
Start Free TrialLog in
Avatar of faiques
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!
ASKER CERTIFIED SOLUTION
Avatar of arrkerr1024
arrkerr1024
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of faiques
faiques

ASKER

I've tried turning off the linux firewall (and the XP firewall) as well with no luck.  Any other thoughts?  Thanks!
Avatar of faiques

ASKER

Need a solution quickly!
Avatar of faiques

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.