The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Connect Excel on M1 Mac to MariaDB Server via ODBC?

Hi all, new here -- I have an M1 Macbook running Excel 365. I have a Debian server on my LAN that's running a MariaDB server - I can connect with no issue from my Macbook using Sequel Pro.

What I'd like to do is setup the MariaDB has an ODBC DSN on my Macbook so that I can use it as a data source in Excel. Is this possible?

I've been playing around with the iODBC Administrator app after installed the MariaDB ODBC 3.2 Unicode driver, but so far no luck.

When I try to add a System DSN, I get this: "[iODBC][Driver Manager]dlopen(/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib, 0x0006): tried: '/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib' (no such file), '/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64'))"

Seems like maybe I have the wrong driver? I ned the arm64 one? Is there an arm64 one? I've been looking but haven't seen one.

Any help would be great, thanks.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.