Debian switched from MySQL to MariaDB since release 9.
And as for now (2017-august-11) it seems that there is no ODBC package for MariaDB connection.
You need to download connector manually from MariaDB website. I tried 3.0.1 (beta) and it didn’t work for me, so I used latest stable (as for now, 2.0.15).
Just download gzipped tar file (not source), unpack it and place libmaodbc.so to /usr/lib/x86_64-linux-gnu/odbc/
After that your odbcinst.ini should look like this:
[MariaDB] Description=MariaDB Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so Setup=/usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so FileUsage=1 UsageCount=1 # not sure if we need 'Setup' at all. As I understood, it's for GUI tool and as you see, # I steel have a wrong lib here :) but now everything works
If you’re in a hurry, you may configure your server right now. But there’s a second part of the story.
As it was my first practice with Debian 9, MariaDB and ODBC connection for it, I haven’t know exactly what packages do I need. It seemed to be clear that some package names will be different in contrast to Debian 8/MySQL+ODBC.
That’s why I installed odbc-mdbtools, thinking that “MDB” means “MariaDB” :-)
Nothing worked, and “isql -v %connector name% %DB user% %DB pass%” command showed that “File not found”. I was confused!
It was my fault that I haven’t read the package description, relying on package name only.
And then, after some hours of research (including my monologue at Linuxquestions) I configured MariaDB + ODBC.