accessing MS Access using DBI on Linux box

[rmayer4]

hey!
I'm trying to connect to a database that was made in MS Access 2000 using the DBI and DBD modules for perl, and everything worked fine during testing (On a Win98 machine)... but now it's all moved onto a Linux machine, and it won't load the drivers!
Do I need to point the ODBC driver to my database, or create a DSN or something?

Either way, here's the error it gives me, let me know if you think of anything!

BI->connect(dmhc01) failed: [iODBC][Driver Manager Specified driver could not be loaded (SQL-IM003) [iODBC][Driver Manager]/home/openlink/lib/oplodbc.so.1: cannot open shared object file:
No such file or directory (SQL-00000)(DBD: db_login/SQLConnect err=-1) at ./example01.cgi line 296 Can't connect to DBI:ODBC:dmhc01 at ./example01.cgi line 296.

Thanks!

Kasey

 

[sleipnir214]

A Microsoft Access database uses a proprietary format, and requires the Microsoft Jet database to access the data. The Jet database engine is not network server software. You have to run Jet on the machine from which you are going to use an Access database.

And there is no Jet engine, or an open source equivalent, on Linux that I know of. It's pretty much pure Win32.


As I see it, you have two choices:
Transfer your data to something not proprietary. MySQL and PostgreSQL are both good choices, and both have ODBC drivers for Win32, which would simplify the transfer.

Use an ODBC-to-ODBC bridge. You leave the database on a Win32 box, and load some server software on it. You then communicate with the database engine on that box via a client you install on your Linux box. Here's a couple. The first is opensource, the second for-pay with a limited-timne trial:

http://freshmeat.net/projects/odbcodbcbridge/?topic_id=66,67,809

http://www.easysoft.com/products/oob/main.phtml

______________________________________________________________________
Perfection in engineering does not happen when there is nothing more to add.
Rather it happens when there is nothing more to take away.

 

[sleipnir214]

Correction. Both of those links will eventually deposit you at EasySoft.

I have found 4 different domain names associated with the opensource ODBC bridge project. Apparently, the registrant let the leases on the domain names lapse. ______________________________________________________________________
Perfection in engineering does not happen when there is nothing more to add.
Rather it happens when there is nothing more to take away.