RE: [PHP] Database abstraction

Uinfied ODBC is NOT ODBC :) it's just a set of <database>_function calls which happen to work similarly in a few databases, so they were put under the "Unified" stuff. I believe this is a misnomer though, since Unified ODBC doesn't use the ODBC API. You can use any real ODBC package to connect to any databases, as long as you can obtain an ODBC driver for that database. You also need a driver manager. The driver manager (one example is iODBC) needs to be compiled into PHP (http://www.iodbc.org/odbc-phpHOWTO.html) An odbc.ini file will hold all the connection parameters that the driver manager will pass to the driver, and initiate connection. The iODBC driver manager is free/open source, to allow the equivalent of the Windows ODBC Administrator on non-Win32 platforms. Drivers are often commercial, especially on non-Win32 platforms. If you compile PHP --with-openlink, you get both the iODBC driver manager and the commercial driver support, or you can use --with-iodbc and use other vendors' ODBC drivers for your database. Hope this helps! Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers > -----Original Message----- > From: Yvonne Rojas [mailto:yrojas@juno.com] > Sent: Thursday, August 24, 2000 11:42 AM > To: php-general@lists.php.net > Subject: Re: [PHP] Database abstraction > > > Andrew, > > The Unified ODBC functions in PHP support only the following > databases: Adabas > D, IBM DB2, iODBC, Solid, and Sybase SQL Anywhere. Do you mean > iodbc support or > the openlink odbc which will connect to both Sybase and Oracle? > > Andrew Hill wrote: > > > Or you could just use ODBC, as this is what it is intended for... :) > > > > Best regards, > > Andrew > > ---------------------------------------------------- > > Andrew Hill > > Professional Services Consultant > > OpenLink Software > > http://www.openlinksw.com > > Universal Database Connectivity Technology Providers > > > > > -----Original Message----- > > > From: Manuel Lemos [mailto:mlemos@acm.org] > > > Sent: Thursday, August 24, 2000 2:28 AM > > > To: Yvonne Rojas > > > Cc: php-general@lists.php.net > > > Subject: Re: [PHP] Database abstraction > > > > > > > > > Hello Yvonne, > > > > > > On 23-Aug-00 12:38:40, you wrote: > > > > > > >I'm trying to build a web application that will access a Sybase > > > >database. However, there is the possibility that it will need to > > > >instead access an Oracle database in the future. Does Php have a > > > >database abstraction layer? Does Php have something similar > to Perl's > > > >DBI? Has anyone used Metabase? > > > > > > About 2.400 individual users downloaded it. I can't say how many > > > effectively use it though. > > > > > > Anyway, if you need database portability, Metabase is a good > choice, in > > > many aspects better than Perl DBI. Not only it provides a > way to develop > > > database applications that are portable between DBMS, but it also it > > > provides a means to design portable database schemas that you > can install > > > and upgrade in any supported DBMS. > > > > > > If some day you need to move between DBMS, you can have > Metabase dump your > > > database contents in DBMS neutral format so you can re-install > > > its contents > > > in a new DBMS without loss of data or type information. > > > > > > The Sybase driver is not yet publically available but it is > on the way. If > > > you want to be warned when a beta version will be available, just > > > subscribe > > > to Metabase development mailing list by sending an empty message to > > > metabase-dev-subscribe@egroups.com or otherwise look in the list Web > > > archive here: > > > http://www.egroups.com/group/metabase-dev > > > > > > > > > > > > Regards, > > > Manuel Lemos > > > > > > Web Programming Components using PHP Classes. > > > Look at: > > > http://phpclasses.UpperDesign.com/?user=mlemos@acm.org > > > -- > > > E-mail: mlemos@acm.org > > > URL: http://www.mlemos.e-na.net/ > > > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp > > > -- > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >