Re: Migrate from .accdb to MySQL

[Sergio de la Cruz]

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.