Bug #73227 Error migrating from MS SQL 2008 SP2 to MySQL
Submitted: 8 Jul 2014 0:30 Modified: 14 Aug 2014 20:37
Reporter: Luca Candela Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S1 (Critical)
Version:6.1.7.11891 build 1788 OS:Microsoft Windows (7)
Assigned to: CPU Architecture:Any

[8 Jul 2014 0:30] Luca Candela
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)
[14 Jul 2014 20:37] MySQL Verification Team
Thank you for the bug report. Which connection method are you applied?. (ODBC)native? Thanks.
[15 Aug 2014 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".