Migration: Exception thrown while using ODBC connections tring
I'm trying to create a migration from a local instance of SQL Server. When I test the connection, the following message appears: 'grt.Dict key must be a string'. Looking in the log, I find this message. How do I resolve this?
```
15:43:30 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/migration_source_selection.py", line 226, in test_connection
if not source.connect():
File "/usr/lib/mysql-workbench/modules/migration.py", line 199, in connect
self._rev_eng_module.connect(self.connection, self.password or "")
SystemError: NotConnectedError("No open connection to Mssql@Driver=ODBC Driver 18 for SQL Server;Server=tcp:localhost,1433;UID=sa;PWD=xx"): error calling Python module function DbMssqlRE.connect
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/migration_source_selection.py", line 331, in go_advanced
self.test_connection(self.main.plan.migrationSource, "Source")
File "/usr/lib/mysql-workbench/modules/migration_source_selection.py", line 256, in test_connection
username = source.connection.parameterValues.userName
KeyError: 'grt.Dict key must be a string'
```
Subject
Views
Written By
Posted
Migration: Exception thrown while using ODBC connections tring
872
September 12, 2022 02:52PM
393
September 12, 2022 09:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.