Page 1 of 1

Connection Error help please...

PostPosted: Fri Mar 15, 2013 6:20 pm
by GhostRider2110
Moving data directly to MySQL server

Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.2w Driver};Extended Properties="SERVER=localhost;UID=root;PWD=********Access;PORT=3306;OPTION=0;STMT=;"
Program Version:
ODBC Version:
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.2(w) Driver]Access denied for user 'root'@'localhost' (using password: YES)

I know that account works, MySQL workbench has no problem connecting.

Any help would be greatly appreciated.


Re: Connection Error help please...

PostPosted: Fri Jun 07, 2013 9:31 pm
by cove3
1. Use Admin Tools/ODBC to test connecton
2. Be sure your hosting MYSQL has enable remote connections checked
3. Make sure your sign in has full priviliges for the database
4. Check if your hosting MYSQL has drop database disabled. If anything is wrong with the script, my x10 host gives a access denied message, rather than any explanation of what the problem is