MySQL Forums
Forum List  »  Microsoft Access

Re: Migrate from .accdb to MySQL
Posted by: Sergio de la Cruz
Date: November 22, 2012 02:48PM

The key to discover what's going on is in these two lines:

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

The ODBC standard defines that every ODBC driver should implement the SQLTables function (wrapped by pyodbc in the tables() function). This function gives information about the tables in a given database. If your driver doesn't implement it (as the second line suggests) then you're not going to get any farther than that.

You should try with another ODBC driver for Access and check how it behaves. I'm sorry I can't give you guidance about which one would work. It would be interesting if you can get one that works and you report back how it went here. You can even write a blog post about it (we can publish that in our blog at mysqlworkbench.org if you don't have one).

Good luck with that.

Sergio A. de la Cruz RodrĂ­guez
Software Developer
Oracle Corp.

Options: ReplyQuote


Subject
Views
Written By
Posted
2818
November 22, 2012 04:05AM
653
November 22, 2012 08:04AM
778
November 22, 2012 08:49AM
594
November 22, 2012 08:56AM
841
November 22, 2012 10:16AM
Re: Migrate from .accdb to MySQL
622
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.