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

Excel+MariaDB driver not showing list of tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 3.1.0, 3.0.8
    • 2.0.19, 3.0.9, 3.1.1
    • General
    • 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

        1. _ExcelTables.png
          32 kB
          Lawrin Novitsky
        2. Excel.png
          13 kB
          IT Particip
        3. SQL.LOG
          121 kB
          IT Particip

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.