Connecting to MS Access database from PHP on Linux O/S

[jwhite68]

Does anyone know if its possible to connect to an MS Access database, via PHP on a Linux O/S.

I had mistakenly assumed that I could achieve this with the ADODB database abstraction layer, since it lists Access as a supported database. However, I now understand that this is limited to PHP running on a Windows Server, due to some library/libraries required.

Any ideas?

I understand UnixODBC can be used together with MDBTools, but my hosting provider does not support UnixODBC.

[firepages]

AFAIK you need an ODBC bridge (UnixODBC, ODBC-ODBC etc) to connect to the remote ODBC datasource & they are rarely free.

...this link (http://www.answer.google.com/answers/threadview?id=32277) suggests otherwise for PERL

Otherwise perhaps consider writing a web-service on the MS host to supply the data via http ?

[rock_14]

MS Access is such a piece of crap that I would recommend sucking all the data into MySQL and then just using it.

There is a way to do what you are asking (I think), but I really think your life would be better if you just sucked everything into MySQL and forgot about that Micro$oft piece of trash.