Error Message - Help please!

Installation and setup related issues.

Moderator: jr

CountryGirl
Posts: 1
Joined: Mon Nov 09, 2009 7:48 pm

Error Message - Help please!

Post 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
jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Re: Error Message - Help please!

Post by jr »

Can you connect to MySQL using ODBC from other programs?

/Jacob
Post Reply