open source solution for extracting data from MS Access on Linux?

[dubing]

Hello,

Here is what we need to do. On a Linux Apache server, we need to
write PHP or Perl scripts to pull the data directly from the Access
database and display extracted data on the web. Anybody have done that
and would like to share how?

I've looked dbmtools. But it seems to be a command line based tool.
Also it's good for transferring data from Access to other databases,
like mysql, db2, etc. I've also tested Easysoft ODBC-ODBC Bridge. It
works for Access. But it's not open source. FreeTDS/unixodbc is open
source but FreeTDS is for MS SQL server and Sybase.

Thanks in advance for any ideas.

Bing

[Beowulf]

I'm just tossing out some ideas.

Do you have access to an ODBC driver for Jet 4.0 in Linux?
You'd be able to then use whatever standard data access tools
are provided by gcc or g++, right?

Alternately, if you can load or link ActiveX DLLs in Linux, then
you could access the data in the MDB file using the ADO object
library (which is freely available through Microsoft's MDAC 2.8
download).

As far as I know, the actual file format for the Access MDB is
proprietary, so I don't know how you'd get at the data outside
of ODBC or ADO. If anyone has found a way to hack it, though,
it'd be someone in the Linux community.

du****@gmail.com wrote:

Hello,

Here is what we need to do. On a Linux Apache server, we need to
write PHP or Perl scripts to pull the data directly from the Access
database and display extracted data on the web. Anybody have done that
and would like to share how?

I've looked dbmtools. But it seems to be a command line based tool.
Also it's good for transferring data from Access to other databases,
like mysql, db2, etc. I've also tested Easysoft ODBC-ODBC Bridge. It
works for Access. But it's not open source. FreeTDS/unixodbc is open
source but FreeTDS is for MS SQL server and Sybase.

Thanks in advance for any ideas.

Bing

[Tom van Stiphout]

On 16 Nov 2005 14:07:39 -0800, du****@gmail.com wrote:

If you can get to SQL Server, you could add the Access database as a
linked server. Just don't expect any performance :-)

-Tom.

Hello,

Here is what we need to do. On a Linux Apache server, we need to
write PHP or Perl scripts to pull the data directly from the Access
database and display extracted data on the web. Anybody have done that
and would like to share how?

I've looked dbmtools. But it seems to be a command line based tool.
Also it's good for transferring data from Access to other databases,
like mysql, db2, etc. I've also tested Easysoft ODBC-ODBC Bridge. It
works for Access. But it's not open source. FreeTDS/unixodbc is open
source but FreeTDS is for MS SQL server and Sybase.

Thanks in advance for any ideas.

Bing

[dubing]

Oh, yeah, linked server, that's a good idea I've never thought of.
Thanks much for the hints!

Bing

[Chad Lupkes]

Hi Tom,

I've been trying to create a simple (I hope) PHP application to send
emails to a membership list. I have yet to successfully connect to my
database to pull the names and email addresses. I'm running XP Pro,
PHP Version 4.3.2, Access 2000. I have created an ODBC System DNS
connection to the database file I want to access, And I get this error:

Warning: SQL error: , SQL state 00000 in SQLConnect in connecttodb.php
on line 2
Whoops! Could Not Connect to ODBC Database!

Here is my code:

<?php
$odbc = odbc_connect ('DFWMembershipDB', '', '') or die('Whoops! Could
Not Connect to ODBC Database!');
?>

I'm a total novice at this, so any help you can provide would be really
appreciated.

Chad Lupkes
Seattle, Washington