Posted by Erwin Moller on 11/02/06 10:06

harsha.patibandla@gmail.com wrote:

> We have a webserver, Apache, hosted on Linux and we use php as the
> scripting language. Now, I am developing a form which will fill up a
> Microsoft Access database (on a Windows machine). For this one needs to
> use an ODBC connection. Now php has default ODBC support
> (http://us2.php.net/odbc ), but I do not think this supports MS Access.
>
> My question is what driver manager/drivers do i need to install for
> this:
> one option was unixODBC, but we do not want to do this as this involves
> rebuilding php.
>
> Will iODBC work? or will the default support work is my doubt.
>
> It would be great if someone can help me with this.
>
> Harsha

Hi Harsha,

I am not sure, but ADODB can maybe help you.
www.phplens.com/adodb
I use that package with great happiness now for years. :-)
It is a database abstractionlayer that let you connect to many databases via
a common API.

There are some threadsafety issues with IIS however, but you use apache.

I never tried to connect to access, so you'll have to figure it out
yourself. :-)

Regards,
Erwin Moller

[Back to original message]