MS Access Reverse Engineering DB Error
I get this error after running the basic migration procedure for MS Access with MySQL 5.3 ANSI Driver database. I tried the other MS Access DB and had no sucess. Please let me know what you think of it. I am trying to get Workbench to open up an ODBC data source so I may save it as a SQL file:
Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=LLLAMySQLConnection...
Connected
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering mysql from def
- Reverse engineering catalog information
- Preparing...
- Gathered stats for mysql
Reverse engineering tables from mysql
[EDITED/abridged: - Retrieving tables...]
- First pass of table reverse engineering for schema mysql completed!
Reverse engineering views from mysql
- Reverse engineering of views for schema mysql completed!
Reverse engineering routines from mysql
- Reverse engineering of routines for schema mysql completed!
Reverse engineering triggers from mysql
- Reverse engineering of triggers for schema mysql completed!
Reverse engineering foreign keys for tables in schema mysql
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 751, in reverseEngineer
return MsAccessReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 351, in reverseEngineer
cls.reverseEngineerTables(connection, schema)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 438, in reverseEngineerTables
cls.reverseEngineerTableFKs(connection, table)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 621, in reverseEngineerTableFKs
for row in cls.get_connection(connection).cursor().execute("SELECT * FROM MSysRelationships WHERE szObject = ?", (table.name,)):
pyodbc.ProgrammingError: ('42S02', "[42S02] [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.17]Table 'mysql.msysrelationships' doesn't exist (1146) (SQLPrepare)")
Traceback (most recent call last):
Subject
Views
Written By
Posted
MS Access Reverse Engineering DB Error
3402
September 23, 2015 05:40PM
1561
December 02, 2015 04:37AM
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.