[ODBC-227] MariaDB ODBC connector does not load in macOS Excel 2019 Created: 2019-03-05  Updated: 2023-12-03

Status: Open
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.0
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Heiko Kirschke Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: excel, macos, odbc
Environment:

macOS 10.14.3, Excel 2019


Issue Links:
PartOf
includes ODBC-406 EXCEL iODBC Sandbox problem Open

 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.



 Comments   
Comment by Javis D. [ 2019-03-24 ]

same issue here for macOS 10.13.2 & EXCEL 2016(v.16.16.5 = 64-bit) , i.e. only 64-bit works.

I have also as OP traced to that github thread (closed) and added my details there:

and also at Microsoft EXCEL for macOS community:

Interesting to see, with iODBC 64, the MariaDB version shows up as 03.01.000, while the non-64 shows ##.##, which maybe another sign that it does not find/recognize the driver to e.g.:
/Library/ODBC/MariaDB-Connector-ODBC/libmaodbc.dylib
(PS: I moved the driver to ODBC/ instead of MariaDB/ as smalinin@github suggested, but not working)


Since libmaodbc.dylib is 64-bit and my EXCEL 2016 also 64-bit, I don't know why EXCEL ODBC manager no use 64-bit to connect?
BTW: LibreOffice (6.1 & 6.2) has no issue.

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