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

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

Hello,

on 09/06/2005 08:22 PM David said the following:
> 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.

You may want to try Metabase that is a long standing PHP database 
abstraction focused on total database independence.

Not only it can provide database independence in the database access but 
also in the database schema installation as it lets you install database 
schemas from a database independence description in a XML format.

It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft 
Access via ODBC, Informix, Interbase, SQLite, MiniSQL.

http://www.phpclasses.org/metabase


-- 

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html