Can't connect to MySQL server
Posted: Wed May 30, 2007 5:50 pm
I am trying to use MS Access to MySQL and have installed the OBDC Connector/Driver....but I am getting the following error when I try to run the convertor and have no idea what I am doing (wrong)? Just trying to convert an access DB to MySQL....
Suggestions?
SETTINGS
--------
Moving data directly to MySQL server
TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 3.51 Driver};Extended Properties="SERVER=localhost;UID=root;PWD=;PORT=3306;OPTION=0;STMT=;"
Program Version: 2.0.0.57
ODBC Version: 3.51.15.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)
Suggestions?
SETTINGS
--------
Moving data directly to MySQL server
TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 3.51 Driver};Extended Properties="SERVER=localhost;UID=root;PWD=;PORT=3306;OPTION=0;STMT=;"
Program Version: 2.0.0.57
ODBC Version: 3.51.15.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)