Can't connect to MySQL server

General usage of Access to MySQL

Moderator: jr

OpenIntro
Posts: 1
Joined: Wed May 30, 2007 4:56 pm

Can't connect to MySQL server

Post by OpenIntro »

I am trying to use MS Access to MySQL and have installed the OBDC Connector/Driver....but I am getting the following error when I try to run the convertor and have no idea what I am doing (wrong)? Just trying to convert an access DB to MySQL....

Suggestions?


SETTINGS
--------
Moving data directly to MySQL server

TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 3.51 Driver};Extended Properties="SERVER=localhost;UID=root;PWD=;PORT=3306;OPTION=0;STMT=;"
Program Version: 2.0.0.57
ODBC Version: 3.51.15.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)
mitsui_ng
Posts: 1
Joined: Sun Aug 10, 2008 3:18 am

Same problem

Post by mitsui_ng »

Hi... I'm having the same problem.
Anyone know the reason why?

Need help...
Hayman
Posts: 2
Joined: Sat Apr 18, 2009 7:10 pm

Re: Can't connect to MySQL server

Post by Hayman »

I to am getting the same error. I use the same user id and logon host in dreamweaver and I conect just fine with dreamweaver to my database
jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Re: Can't connect to MySQL server

Post by jr »

Please try the latest version of the program and a version 5.x ODBC driver from MySQL.

/Jacob
Post Reply