MySQL Forums
Forum List  »  Connector/ODBC

Re: unable to load mysql ODBC 8.0 unicode driver on Excel for mac
Posted by: Bogdan Degtyariov
Date: May 01, 2023 05:16PM

There are MySQL drivers for x86 and ARM (M1/M2) architecture.
You don't have to pay for the community version.
It is possible that the contents of your odbc.ini and odbcinst.ini files are not right.

Can you copy/paste them here with the asterisk-ed (***) passwords?
As said before - another possibility is misconfiguration of iODBC when it cannot find the .ini files. You can help iODBC to find odbc.ini by setting the environment variable ODBCINI=/path/to/odbc.ini

For odbcinst.ini you need to specify only the directory where the file is located without the actual file name as: ODBCINSTINI=/path/to/

Another consideration is that iODBC driver manager compiled for x86 should work with x86 ODBC drivers. Same should be done if iODBC is for ARM. If it is for both architectures x86 and ARM you should choose ARM ODBC driver.

Finally, you can try to diagnose if the driver library or installation is corrupted.
To do this you can use the dltest command line tool installed together with MySQL Connector/ODBC:

$ dltest /path/to/odbc/myodbc8a.so

Options: ReplyQuote


Subject
Written By
Posted
Re: unable to load mysql ODBC 8.0 unicode driver on Excel for mac
May 01, 2023 05:16PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.