[ODBC-297] Listing a Database with name fem also lists the DB fem_ba Created: 2020-11-17  Updated: 2020-12-11  Resolved: 2020-12-11

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.10
Fix Version/s: 3.1.11

Type: Bug Priority: Major
Reporter: Arne Schwarck Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 10, Access 2019

Attachments: PNG File 9F5E1021.PNG    
Issue Links:
Relates
relates to ODBC-298 Make "MS Access" behavior of SQLTable... Closed

 Description   

Linking through the ODBC with a DSN of DATABASE=fem
It also works with fem_*, where * can be anything.
This will list the names of the tables but will run into an error when trying to connect a table that does not fit to the database name.

Using pyODBC it does list correctly so the issue must be the Access 2019 and the maodbc.dll
It must be said the driver was not completely install but only the dll copied to the windows 10 system.

 Comments   
Comment by Arne Schwarck [ 2020-11-17 ]

This Error also occurs in Access 2016

Comment by Lawrin Novitsky [ 2020-12-11 ]

When requesting list of tables for the table linking dialog, MS Access passes NULL catalog(and schema) name. We interpreted ODBC specs, that that is equivalent of requesting tables from all databases. Apparently only current DB tables are expected in this case by MS Access. And we should trust MS's interpretations of own specs.
The fix for this bug change SQLTables behavior in the above described scenario only if the connector is used by MS Access. In future versions of the connector it will be made default.

Commit 16e4061

Generated at Thu Feb 08 03:27:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.