ODBC and JET Databases in Linux

How can you setup ODBC on Linux for JET Databases?

I've tried with both UNIXOdbc and iODBC but I can't seem to get it to work...

Could somenone provide some guidance?

Edit

I must open and run some queries on *.mdb files (native Access databases' format). On windows I use Python and the library pydobc. I would like to be able to run my code from linux too. I could propably just use mdb-tools to extract the data but I would prefer it if I could directly connect to the database (maybe I will need to add some tabl开发者_Go百科es and redistribute the *.mdb file).

Its commercial but this should do what you need.

http://www.easysoft.com/products/data_access/odbc-access-driver/index.html

In addition to iODBC you will need an ODBC driver too...

One such ODBC driver is the OpenLink Multi-tier ODBC to ODBC Bridge

Any luck? In case it still does not work, do you have a proper ODBC driver for that database, because ODBC compliant applications do not have to have UnixODBC or anything like that installed. All of that is usually done inside of the application itself which reads the connection string, and reacts properly. If it finds DSN, it needs to find the entry for this DSN, but if you add DRIVER= and this driver is a path to an .so file, it should load the driver without searching for .odbcinst.ini or anything like that.