Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
3.1.0, 3.0.8
-
None
-
Windows 10, Excel 2016
Description
Dear support,
We are facing an issue with the connection between Microsoft Excel and our MariaDB database using the MariaDB driver.
When trying to connect to the database in Microsoft Excel through Data -> Get data -> from other sources -> from ODBC, I select the DSN and get the databases shown, but not the list of tables (see attachment). Without seeing the tables, we are not able to use Power Query in Excel properly.
I've tested it with MariaDB ODBC driver 3.08 and 3.1.0 and both show no tables. When I do the same with the Mysql ODBC driver 8.0.15 I get the list of tables without problems.
I am niot sure if this is a bug in the mariadb driver, a compatibility issue or a misconfiguration from our side.
Could you sheed some light on this matter?
Thanks a lot for your support
Attachments
Issue Links
- is duplicated by
-
ODBC-244 Microsoft Excel 365 ODBC Navigator can't find tables
- Closed