unixodbc mdbtools Driver= setting

[k829king]

following sudo apt-get install unixodbc and odbc-mdbtools I have an /etc/odbcinst.ini of

Code: Select all

[MDBTools]
Description=MDBTools Driver
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
FileUsage=1
UsageCount=1


All doco I can find suggest the local (or /etc) based odbc.ini should have e.g.

Code: Select all

[MyTestB]
Description = MyTestB
Driver = MDBTools
Servername = localhost
Database = /home/user01/Northwind.mdb
Name =
Password =
port = 5432

But isql fails to connect, if I change the driver line to physical full path of driver as below it works

Code: Select all

[MyTestB]
Description = MyTestB
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
Servername = localhost
Database = /home/user01/Northwind.mdb
Name =
Password =
port = 5432

isql all works but I'm curious why the as per doco approach doesn't seem to work. I've just tried this on Deb10 and Deb11 Alpha3 with same results

Update: It is only mdbtools that seems to have the issue, just tested sqlite and it works as per doco