[IM001] [unixODBC][Driver Manager]Driver does not support this function (0) (SQLPrimaryKeys)

[ReubenFrankel]

Following this comment, I get the following error when trying to get primary keys via pyodbc:

Python 3.8.18 (default, Aug 24 2023, 19:48:18) 
[GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> db = pyodbc.connect("Driver=MDBTools;DBQ=sample_db/Books.mdb")
>>> [t[2] for t in db.cursor().tables()]
['MSysObjects', 'MSysACEs', 'MSysQueries', 'MSysRelationships', 'All Titles', 'Authors', 'f_080E88E79F6E4B6EB728E20CB412E242_Data', 'MSysAccessStorage', 'MSysIMEXColumns', 'MSysIMEXSpecs', 'MSysNavPaneGroupCategories', 'MSysNavPaneGroups', 'MSysNavPaneGroupToObjects', 'Publishers', 'Title_Author', 'Titles', 'MSysNavPaneObjectIDs']
>>> [pk for pk in db.cursor().primaryKeys("Authors")]
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
pyodbc.InterfaceError: ('IM001', '[IM001] [unixODBC][Driver Manager]Driver does not support this function (0) (SQLPrimaryKeys)')

[AoungY]

I had the same problem

[CoreyVincent]

Same