Cant connect to remote database via MyODBC 3.51.20
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)