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)
Can't connect to MySQL server
Moderator: jr
Same problem
Hi... I'm having the same problem.
Anyone know the reason why?
Need help...
Anyone know the reason why?
Need help...
Re: Can't connect to MySQL server
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
Please try the latest version of the program and a version 5.x ODBC driver from MySQL.
/Jacob
/Jacob