[CentOS] Using an MS Access database from CentOS release 5.7 (Final)

Smithies, Russell Russell.Smithies at agresearch.co.nz
Thu Dec 15 02:05:35 UTC 2011


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 at centos.org [mailto:centos-bounces at 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 at 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 at gmail.com
> _______________________________________________
> CentOS mailing list
> CentOS at 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.
=======================================================================



More information about the CentOS mailing list