Posted by Adamski on 11/26/06 11:16

On Thu, 19 May 2005 19:45:50 +0200, Jonathan wrote:

>R Kay wrote:
>> I have a requirement to allow PHP to extract data from an existing
>> Access database. The PHP (v4) is hosted on an apache / linux server.
>>
>> Any pointers / help would be greatly appreciated
>
>Maybe this can be a solution for you, it uses ODBC and php to access the
>MS Access database.
>
>http://www.phpfreaks.com/tutorials/61/0.php

That's a tutorial on setting up/using ODBC on Win32 - the OP needs to
have it running on Linux.

I'm sure it's possible, as I once configured ColdFusion with ODBC on a
Red Hat server ... but it was so long ago ago, I've forgotten what I
did :-((

I'd be interested to know of a Linux solution as well, as I have a few
sites that are currently hosted on IIS and require to have their
databases in Access (don't ask!).

To the OP - note that Access uses JetSQL, which is slightly different
to MySQL query syntax. You may need to dig around a little -
particularly with respect to formatting of date/timestamps.

Adam.

[Back to original message]