Description:
While trying to migrate a database from MS SQL 2008 R2 SP2 to MySQL using the Workbench, I ran into this error:
Error:
Error("('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001);
there is no message for this error. (-1001) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion
Complete error log:
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to Mssql@MSTRAnalyticsDesktop...
Opening ODBC connection to DSN=MSTRAnalyticsDesktop;DATABASE=;UID=luca;PWD=XXXX...
Connected to Mssql@MSTRAnalyticsDesktop,
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\db_mssql_grt.py", line 148, in connect
_connections[connection.__id__]["version"] = getServerVersion(connection)
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\db_mssql_grt.py", line 174, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.Error: ('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001); there is no message for this error. (-1001) (SQLExecDirectW)')
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\db_mssql_grt.py", line 174, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.Error: ('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001); there is no message for this error. (-1001) (SQLExecDirectW)')
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\workbench\wizard_progress_page_widget.py", line 66, in run
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.1.7\modules\migration_source_selection.py", line 426, in task_connect
raise e
SystemError: Error("('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001); there is no message for this error. (-1001) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion
ERROR: Error during Connect to source DBMS: Error("('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001);
there is no message for this error. (-1001) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion
ERROR: Exception in task 'Connect to source DBMS': SystemError('Error("(\'HY000\', \'[HY000] [Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001); there is no message for this error. (-1001) (SQLExecDirectW)\')"): error calling Python module function DbMssqlRE.getServerVersion',)
Failed
How to repeat:
1. Install MS SQL 2008 R2 SP2
2. Restore Contoso BI Demo into database (http://www.microsoft.com/en-us/download/details.aspx?id=18279)
3. Migrate data from MS SQL to MySQL using workbench (leave all options as is)