MySQL Forums
Forum List  »  MySQL Workbench

Unhandled exception: 'grt.Dict key must be a string' when testing connection in MySQL Workbench Migration Wizard
Posted by: Les Miazga
Date: January 19, 2023 10:03PM

I’m trying to connect to MS Access database using ODBC driver and I’m getting an “Unhandled exception: ‘grt.Dict key must be a string’” error

Following is the log file record:

21:41:13 [INF][ grt]: Connecting to …
21:41:13 [INF][ grt]: Opening ODBC connection to DSN=API DB…
21:41:13 [ERR][ python]: error calling DbMsAccessRE.connect
Traceback:
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_msaccess_re_grt.py”, line 701, in connect
return MsAccessReverseEngineering.connect(connection, password)
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_msaccess_re_grt.py”, line 152, in connect
con = db_driver.connect(connection, password)
File “C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py”, line 95, in connect
connection = library.connect(connection_string, password=password)
NameError: (‘42000’, ‘[42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905) (SQLDriverConnect); [42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905)’)
21:41:13 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py”, line 226, in test_connection
if not source.connect():
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py”, line 199, in connect
self._rev_eng_module.connect(self.connection, self.password or “”)
SystemError: ProgrammingError(“(‘42000’, ‘[42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905) (SQLDriverConnect); [42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905)’)”): error calling Python module function DbMsAccessRE.connect

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py”, line 331, in go_advanced
self.test_connection(self.main.plan.migrationSource, “Source”)
File “C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py”, line 256, in test_connection
username = source.connection.parameterValues.userName
KeyError: ‘grt.Dict key must be a string’

Any help would be appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unhandled exception: 'grt.Dict key must be a string' when testing connection in MySQL Workbench Migration Wizard
689
January 19, 2023 10:03PM


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.