By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 16 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 17 '05 #2

P: n/a
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


Nov 17 '05 #3

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

Bing

Nov 17 '05 #4

P: n/a
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

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.