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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.0
    • Fix Version/s: None
    • Component/s: General
    • Labels:
    • Environment:
      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

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            hkirschk Heiko Kirschke
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration