mysql - 当我执行从 sql server 到 mysql 的迁移时，工作台中出现以下错误

Question

当我执行从 sql server 到 mysql 的迁移时，工作台中出现以下错误。

Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to Mssql@DRIVER=SQL Server;SERVER=IPAddress\SQLEXPRESS...
Opening ODBC connection to DRIVER={SQL Server};SERVER=IPAddress\SQLEXPRESS;DATABASE={};UID=sa;PWD=XXXX;...
ERROR: Connection failed: No open connection to Mssql@DRIVER=SQL Server;SERVER=IPAddress\SQLEXPRESS
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_mssql_grt.py", line 124, in connect
    con = db_driver.connect(connection, password)
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\db_driver.py", line 91, in connect
    connection = library.connect(connection_string, password=password)
pyodbc.Error: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (67)')
Connecting to Mssql@DRIVER=SQL Server;SERVER=IPAddress\SQLEXPRESS...
Opening ODBC connection to DRIVER={SQL Server};SERVER=IPAddress\SQLEXPRESS;DATABASE={};UID=sa;PWD=XXXX;...
ERROR: Connection failed: No open connection to Mssql@DRIVER=SQL Server;SERVER=IPAddress\SQLEXPRESS
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_mssql_grt.py", line 124, in connect
    con = db_driver.connect(connection, password)
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\db_driver.py", line 91, in connect
    connection = library.connect(connection_string, password=password)
pyodbc.Error: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (67)')

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 66, in run
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration_source_selection.py", line 443, in task_connect
    raise e
SystemError: Error("('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (67)')"): error calling Python module function DbMssqlRE.connect
ERROR: Error during Connect to source DBMS: Error("('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect);
 [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (67)')"): error calling Python module function DbMssqlRE.connect
ERROR: Exception in task 'Connect to source DBMS': SystemError('Error("(\'08001\', \'[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (67)\')"): error calling Python module function DbMssqlRE.connect',)

Failed

所以有人可以帮我解决这个问题吗？

谢谢

Answer 1

您需要使用文本编辑器尝试从您的站点进行一些诊断。

1)打开C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_mssql_grt.py 文件，用记事本或 Notepad++ 在174行附近你会发现一行看起来喜欢:

 ver_string = execute_query(connection, "SELECT SERVERPROPERTY('ProductVersion')").fetchone()[0]

2) 将其更改为:

ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

然后保存并重试。谢谢!

引用:https://bugs.mysql.com/bug.php?id=66030