@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x.
Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers.
Regards,
Ron Young 919-621-9015 http://www.linkedin.com/in/ronhyoung
+++++++++++++++++++ Little tiny dreams require little tiny thoughts and little tiny steps. Great big dreams require great big thoughts and little tiny steps. +++++++++++++++++++ Kosh: The avalanche has already started. It is too late for the pebbles to vote.
On Wed, Dec 14, 2011 at 3:21 PM, Ron Young ronyoung@nc.rr.com wrote:
@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x.
Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers.
The best approach to doing this is to convert the access tables to use a sql server instead of the native mdb. This may or may not be practical/easy, but access can work over ODBC with the db on linux/postgresql (among others) where you would have a matching php client. Next best would be to write something to give web server access to the data you need on the windows box, and access it remote via http.
Try the Sybase driver. I can connect Perl to Microsoft SQL Server using Sybase drivers it so might work with Access. Parts of this might be useful: http://www.peceny.de/misc/freetds.html
--Russell
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Les Mikesell Sent: Thursday, 15 December 2011 10:58 a.m. To: CentOS mailing list Subject: Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
On Wed, Dec 14, 2011 at 3:21 PM, Ron Young ronyoung@nc.rr.com wrote:
@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x.
Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers.
The best approach to doing this is to convert the access tables to use a sql server instead of the native mdb. This may or may not be practical/easy, but access can work over ODBC with the db on linux/postgresql (among others) where you would have a matching php client. Next best would be to write something to give web server access to the data you need on the windows box, and access it remote via http.
-- Les Mikesell lesmikesell@gmail.com _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
======================================================================= Attention: The information contained in this message and/or attachments from AgResearch Limited is intended only for the persons or entities to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipients is prohibited by AgResearch Limited. If you have received this message in error, please notify the sender immediately. =======================================================================
On 12/14/11 6:05 PM, Smithies, Russell wrote:
I can connect Perl to Microsoft SQL Server using Sybase drivers it so might work with Access. Parts of this might be useful:http://www.peceny.de/misc/freetds.html
Access native databases use the 'Jet' database engine, and they are files accessed over SMB/CIFS, not proper client-server like a 'real' database engine.
This is going to be painful no matter how you do it.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Ron Young said the following on 14/12/11 22:21:
@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I had to import some customer's data from an Access application for a new (PHP) version of that application I wrote.
I used mdbtools http://mdbtools.sourceforge.net/
I scripted the conversion this way:
mdb-export -I -S -X -DF accessfile.mdb "accesstablename" | sed 's/accesstablename/sqltablename/g' | sed 's/$/;/g' > /tmp/aaa cat header.sql /tmp/aaa > import.sql mysql --user=user --password=password < import.sql
header.sql file contains just this line:
use database;
Ciao, luigi
- -- / +--[Luigi Rosa]-- \
It is not the strongest of the species that survives, nor the most intelligent, but the one most responsive to change. --Charles Darwin
On 12/15/2011 05:45 AM, Luigi Rosa wrote:
I used mdbtools http://mdbtools.sourceforge.net/
This is also found in the epel repository.
Mogens
-
John R Pierce -
Les Mikesell -
Luigi Rosa -
Mogens Kjaer -
Ron Young -
Smithies, Russell