CODEWITHSUNDEEP
databaselinuxodbcjet
pmav99
pmav99

Reputation: 2057

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 tables and redistribute the *.mdb file).

Upvotes: 0

Views: 1480

Answers (3)

Grzegorz
Grzegorz

Reputation: 3355

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.

Upvotes: 0

Nick Gorham
Nick Gorham

Reputation: 1143

Its commercial but this should do what you need.

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

Upvotes: 1

Garry M. Biggs
Garry M. Biggs

Reputation: 230

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

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

Upvotes: 0

Related Questions