Lost connection to MySQL server in Windows XP while adding Data Source - ODBC

Question

When I am trying to connect to the localhost, there is no problem. But when I am connecting to my server, I am getting this error.

[08S01][MySQL][ODBC 5.1 Driver] Lost connection to MySQL server at ‘reading initial communication packet’, system error: 2

Please tell me how to work around this. I have tried with MySQL ODBC Drivers, both 3.51 and 5.1 drivers.

Answer 1

An ODBC connection to MySQL cannot be made through HTTP (or PHPMyAdmin).

How are you trying to connect?

Edit: time-out may also be an issue. Change the connect_timeout global variable to 30 seconds (or some other 'long' time) and see whether that helps.