[ODBC-225] Excel+MariaDB driver not showing list of tables Created: 2019-02-21  Updated: 2019-09-23  Resolved: 2019-04-25

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.0, 3.0.8
Fix Version/s: 2.0.19, 3.0.9, 3.1.1

Type: Bug Priority: Critical
Reporter: IT Particip Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 1
Labels: None
Environment:

Windows 10, Excel 2016

Attachments: PNG File Excel.png     Text File SQL.LOG     PNG File _ExcelTables.png    
Issue Links:
Duplicate
is duplicated by ODBC-244 Microsoft Excel 365 ODBC Navigator ca... Closed

 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

 Comments   
Comment by Lawrin Novitsky [ 2019-02-21 ]

Thank you for your bug report? What Office version do you use? Because I tried with the Excel I have, and tables list is showed there without problems. I have attached printscreen.
But actually unlikely excel version would help me. Could you please generate ODBC trace for your load data from MariaDB server. That would be more helpful

Comment by IT Particip [ 2019-02-22 ]

Hi Lawrin,

Thanks for your quick answer. We are using Office 365 Pro Plus and I just tested it with the last version of the driver (3.0.1).

I am sending you the odbc trace. I actually wanted to do it yesterday but I didn't find how. I hope it helps us out to find the issue.

Regards

Comment by Peter Godwin [ 2019-03-15 ]

I had a similar issue in SSIS and had to add 

SET sql_mode = 'ORACLE';

to the Initial Statements on the DSN.

Comment by Jean-Claude [ 2019-03-19 ]

I have the same issue between excel365 and mariadb 10.3.13 (mariaDB ODBC 3.00.08.00)

UPDATE: same issue with the version 3.1

Comment by Fabio Valeri [ 2019-09-23 ]

It is not clear for me why this bug report is closed. Could this bug be solved? I have version mariadb-10.4.8-winx64 and I still have this bug.

Comment by IT Particip [ 2019-09-23 ]

The mentioned MariaDB ODBC driver updates solved the issue for us a couple of months ago.

Comment by Geoff Montee (Inactive) [ 2019-09-23 ]

giordano,

I have version mariadb-10.4.8-winx64 and I still have this bug.

The MariaDB Server version doesn't matter. The MariaDB Connector/ODBC version is what matters. If you're still seeing this bug, then you need to upgrade MariaDB Connector/ODBC.

MariaDB Connector/ODBC 3.1.4 is the latest release available at the moment:

https://mariadb.com/kb/en/library/mariadb-connector-odbc-314-release-notes/

http://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.4/

Comment by Fabio Valeri [ 2019-09-23 ]

Sorry, I meant mariadb-connector-odbc-3.1.3-win64. I solved it using mysql-connector-odbc-8.0.17-winx64. I will try the newest version of mariadb-connector-odbc.

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