Link to home
Start Free TrialLog in
Avatar of bud144
bud144Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Cannot connect to mysql database

Hi
Has anyone got any ideas why I cannot connect to my sql database?
This is the error message I receive:

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=webtestc_russell;PWD=********;PORT=3306;OPTION=0;STMT=;"
Program Version: 3.0.0.138
ODBC Version: 5.1.8.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
thanks in advance for any suggestions
bud
ASKER CERTIFIED SOLUTION
Avatar of NDarkstar
NDarkstar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bud144

ASKER

Thanks for your reply
I turned off the router & connection firewalls but still same error?
any other ideas appreciated
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bud144

ASKER

yes i did turn off the windows firewall completely
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial