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.
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.
精彩评论