XCA 2.6 on macOS - mySQL ODBC issue

[Henri0404]

Hi,

receive this message, even the driver is installed, macOS 14.4.

Der folgende Fehler ist aufgetreten:
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, IM002 QODBC: Unable to connect

#ls -l /usr/local/opt/libiodbc/lib/libiodbc.2.dylib
lrwxr-xr-x 1 root wheel 58 Mar 12 17:57 /usr/local/opt/libiodbc/lib/libiodbc.2.dylib -> /opt/homebrew/Cellar/libiodbc/3.52.16/lib/libiodbc.2.dylib

Thanks

Henri

[chris2511]

See: https://mariadb.com/kb/en/creating-a-data-source-with-mariadb-connectorodbc/

You need at least mariadb-connector-odbc and a .odbc.ini like this in your home directory:

[Default]
Description = MariaDB Driver
Driver      = /opt/homebrew/lib/mariadb/libmaodbc.dylib
Database    = xca
Server      = mariadbsql.local

Afterwards a

isql -v Default <sqluser> <sqlpass>

worked.
But: xca did not:

Error: The following error occurred:
?????????????????

and I have no clue why. Maybe it works for you.