Page 1 of 1

Error Message - Help please!

Posted: Mon Nov 09, 2009 7:52 pm
by CountryGirl
I keep getting this error message when I try to transfer my Access db to MySQL -

Moving data directly to MySQL server

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:
ODBC Version:
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!!


Re: Error Message - Help please!

Posted: Sun Oct 03, 2010 2:26 pm
by jr
Can you connect to MySQL using ODBC from other programs?