unixodbc mdbtools Driver= setting

Kernels & Hardware, configuring network, installing services

unixodbc mdbtools Driver= setting

Postby k829king » 2021-01-22 12:07

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
k829king
 
Posts: 90
Joined: 2018-08-26 09:47

Return to System configuration

Who is online

Users browsing this forum: No registered users and 15 guests

fashionable