MySQL Forums
Forum List  »  Microsoft Access

Re: Migrate from .accdb to MySQL
Posted by: Paolo Ermini
Date: November 22, 2012 08:49AM

Thanks for answer ;)

In fact I'm using Microsoft SQL Server... now it works ;)

But now I have a new problem :(
During "Reverse engineer Source" step, I have this log:



Starting...

Connect to source DBMS...

- Connecting...

Connecting to ...

Opening ODBC connection to DSN=DATI_2...

Connected

Connect to source DBMS done

Reverse engineer selected schemata....

Reverse engineering accdb.None from C:\DATI

- Reverse engineering catalog information

- Preparing...

Traceback (most recent call last):

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 683, in reverseEngineer

return GenericReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 228, in reverseEngineer

table_count_per_schema[schema_name] = len(cls.getTableNames(connection, catalog_name, schema_name)) if get_tables else 0

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 176, in getTableNames

cls.get_connection(connection).cursor().tables(catalog=catalog_name, schema=schema_name) if row.table_type=='TABLE'))

pyodbc.Error: ('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')



Traceback (most recent call last):

File "C:\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 191, in thread_work

self.func()

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\migration.py", line 332, in reverseEngineer

self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)

SystemError: Error("('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

ERROR: Reverse engineer selected schemata: Error("('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

Failed



do you have any good hint for me?
Thanks ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
3059
November 22, 2012 04:05AM
730
November 22, 2012 08:04AM
Re: Migrate from .accdb to MySQL
874
November 22, 2012 08:49AM
678
November 22, 2012 08:56AM
1206
November 22, 2012 10:16AM
711
November 22, 2012 02:48PM


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.