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

MariaDB ODBC connector does not load in macOS Excel 2019

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.0
    • None
    • General
    • macOS 10.14.3, Excel 2019

    Description

      I just tried the new ODBC driver for macOS & Excel 2019. Configuration & connection to database works with the iODBC Administrator64 tool (after some tweaking with the directories for openssl and iodbc libraries). When trying to connect via Excel I get that well-known IM003 error that the database driver cannot be loaded. Same happens initially for the mySQL ODBC driver. Assumed reason is that Excel is sandboxed and does not allow loading of executable code from arbitrary lcocations (I assume locations like /usr/local/opt/... used by the .dylib to load dynamic libraries), see reason & workaround at https://github.com/openlink/iODBC/issues/29 at posting of `smalinin commented on 6 Mar 2018'. The workaround using the mySQL OBDC driver binaries & file locations works also for accessing a MariaDB. The workaround does not work for the MariaDB ODBC driver binaries since it tries to link to libraries not allowed by the Excel sandbox.

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              hkirschk Heiko Kirschke
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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