On Wed, Dec 14, 2011 at 3:21 PM, Ron Young <ronyoung@xxxxxxxxx> 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@xxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
