SETTINGS
--------
Moving data directly to MySQL server
TABLES
------------
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: 5.1.0.232
ODBC Version: 5.2.4.0
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.
See-ya
Mitch
Connection Error help please...
Moderator: jr
Re: Connection Error help please...
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
Ron
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
Ron