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
Error Message - Help please!
Moderator: jr
Re: Error Message - Help please!
Can you connect to MySQL using ODBC from other programs?
/Jacob
/Jacob