Posted by ManChild on 09/07/05 03:23

David wrote:
> Is there a good DataBase Abstraction layer that will handle the
> mySql, Sql Server, and MS Access engines? I do not wish to write the
> same functions with the three different PHP db functions.
>
> I see that php_dba is listed as an extension, but I determine which
> DBs are supported. However, I think that it does not support the ones
> I need.
>
> Thanks
>

Pear does not directly support Access -- but it supports ODBC and
that'll work, otherwise you could use the PHP ODBC functions.

www.php.net/odbc
http://pear.php.net/package/DB

Avoid the Microsoft SQL Server functions like the damned plague if you
are using Windows for you webserver. They entirely suck -- I wrote my
own wrapepr for that includes OCI8 MySQL and ODBC seems to work great
with SQL Server.

James

[Back to original message]