Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-225

Excel+MariaDB driver not showing list of tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.1.0, 3.0.8
    • Fix Version/s: 2.0.19, 3.0.9, 3.1.1
    • Component/s: General
    • Labels:
      None
    • Environment:
      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

        1. _ExcelTables.png
          _ExcelTables.png
          32 kB
        2. Excel.png
          Excel.png
          13 kB
        3. SQL.LOG
          121 kB

          Issue Links

            Activity

              People

              Assignee:
              Lawrin Lawrin Novitsky
              Reporter:
              IT_Particip IT Particip
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration