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 -

"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

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?

/Jacob