CODEWITHSUNDEEP
sqlmysqlwindows-xpodbcodbc-sql-server-driver
user279244
user279244

Reputation: 971

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

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.

Upvotes: 0

Views: 3105

Answers (1)

Tobiasopdenbrouw
Tobiasopdenbrouw

Reputation: 14039

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.

Upvotes: 0

Related Questions