Re: Re: Unified DB Query function

Hello, On 07/25/2002 02:34 PM, Andrew Hill wrote:

Pierre, Why not use ODBC functions everywhere?

I already told you before. ODBC is very weak API for real database abstraction. To make it worse, PHP ODBC API is buggy and not as complete as it could be. As the maintainer of PHP ODBC support, if you are willing to do anything about it, I can help you to pin point the problems that need to be addressed. Otherwise it is quite pointless to even consider using ODBC in PHP unless it is your really alternative. Regards, Manuel Lemos

Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -----Original Message----- From: Pierre-Alain Joye [mailto:paj@pearfr.org] Sent: Monday, July 01, 2002 1:01 PM To: mlemos@acm.org Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Unified DB Query function On Mon, 01 Jul 2002 14:55:01 -0300 Manuel Lemos <mlemos@acm.org> wrote:

Hello, On 07/01/2002 06:46 AM, Casey Allen Shobe wrote:

I'm trying to write a unified database query function for an

application I

have which currently accesses data from both DB2 and Microsoft SQL

from a

Linux server. I'm using ODBC functions for DB2, and Sybase

functions for

Microsoft SQL.

Why do you re-invent the wheeel and don't you use a database

abstraction

package that handles the database differences of you, like for

instance

Metabase: http://www.phpclasses.org/metabase

Just because diversity rules in our world :). btw, do you have samples codes using the xxxxxDefinition methods in metabase ? pa