|
|
Posted by Adamski on 10/20/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.
Navigation:
[Reply to this message]
|