Error: -2147417848

[GarySprunk]

Every time I try to move a table into a MySQL database I get the error:

Program Version: 2.0.0.46
ODBC Version: 5.0.0.0
Function: modMySql.MoveData2MySql
Error: -2147417848
Reason: Method '~' of object '~' failed
SQL: CREATE DATABASE IF NOT EXISTS `newbackend`

I Googled the error #; it is very general; I don't know what to change.

[jr]

The MySQL ODBC driver 5.0 will not do the job. You have to go to http://dev.mysql.com/downloads/connector/odbc/3.51.html and download version 3.51. This version is much better