Error Message - Help please!
Posted: Mon Nov 09, 2009 7:52 pm
I keep getting this error message when I try to transfer my Access db to MySQL -
"SETTINGS
--------
Moving data directly to MySQL server
TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=localhost;UID=wcassessor;PWD=wca4736;PORT=3306;OPTION=0;STMT=;"
Program Version: 3.0.0.117
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)"
Why is this? I have the right MySQL version, the right ODBC and the right Access to MySQL. I don't see a spot to put the name of the exact MySQL database to transfer to. How can I get around this?????
Thanks for any and all help!!
Qadoshyah
"SETTINGS
--------
Moving data directly to MySQL server
TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=localhost;UID=wcassessor;PWD=wca4736;PORT=3306;OPTION=0;STMT=;"
Program Version: 3.0.0.117
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)"
Why is this? I have the right MySQL version, the right ODBC and the right Access to MySQL. I don't see a spot to put the name of the exact MySQL database to transfer to. How can I get around this?????
Thanks for any and all help!!
Qadoshyah