MySQL Forums
Forum List  »  Microsoft Access

MS Access Reverse Engineering DB Error
Posted by: Jason Safronoff
Date: September 23, 2015 05:40PM

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):

Options: ReplyQuote


Subject
Views
Written By
Posted
MS Access Reverse Engineering DB Error
1907
September 23, 2015 05:40PM


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.