Page 1 of 1

Can't connect to MySQL server

Posted: Wed May 30, 2007 5:50 pm
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)

Same problem

Posted: Sun Aug 10, 2008 3:23 am
by mitsui_ng
Hi... I'm having the same problem.
Anyone know the reason why?

Need help...

Re: Can't connect to MySQL server

Posted: Tue Apr 21, 2009 5:45 pm
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

Re: Can't connect to MySQL server

Posted: Thu Apr 23, 2009 10:24 am
by jr
Please try the latest version of the program and a version 5.x ODBC driver from MySQL.

/Jacob