Re: [PHP-DB] PHP vs. 2 database softwares
Scott Fletcher wrote: > Do you meant to say that it took me several days to figure out that PHP > doesn't support multiple databases? PHP said it will work with almost any > databases but it failed to meant to say that only "with" one databases, but > not multiple databases at the same time. > PHP will work with multiple databases, as long as you don't try to use any of the uodbc based flavors together (Solid, Empress ,iODBC, unixODBC, Easysoft OOB, OpenLink, Adabas D, Velocis, DBMaker, SAP DB and IBM DB2). If you need to connect to multiple ODBC databases, use a driver manager such as iODBC or unixODBC and the appropriate ODBC driver. > Never mind the problem. I found that PHP won't use both the > "--with-ibm-db2" option and "--with-iobc" option, it only can use one of > them. As oulined above, instead of using "--with-ibm-db2" and "--with-iodbc" just use "--with-iodbc" and create a DSN for your DB2 server with iodbc. -Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP vs. 2 database softwares
On Mon, 1 Oct 2001, Scott Fletcher wrote: > Date: Mon, 1 Oct 2001 12:11:12 -0400 > From: Scott Fletcher <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP vs. 2 database softwares > > Hi! > > I found that PHP can be compiled and work with only one database > software. You won't be able to have PHP to work with 2 seperate database > softwares. (You can compile it but it will work only with one databse > software, not both, no matter what). I checked the php "./configure" file > and found that it is not design to include 2 seperate databases when you > want it to. I used ./configure in order to access Oracle and MySQL and it worked. Adi Wibowo -- http://dewey.petra.ac.id * Work matter: [EMAIL PROTECTED] * Private matter : [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP vs. 2 database softwares
Scott, I didn't know that you couldn't use multiple database protocols at once, and this does surprise me to. ODBC is a way around this problem, however, abstracting the protocol for you. Cheers, Andrew > -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:39 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP vs. 2 database softwares > > > Do you meant to say that it took me several days to figure out that PHP > doesn't support multiple databases? PHP said it will work with almost any > databases but it failed to meant to say that only "with" one > databases, but > not multiple databases at the same time. > > Scott > "Andrew Hill" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Scott, > > > > That is what ODBC is for. > > Compile --with-iodbc as per the howto at www.iodbc.org > > and you can use ODBC drivers for multiple database platforms at the same > > time. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Data Integration Technology Providers > > > > > -Original Message- > > > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, October 01, 2001 12:11 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] PHP vs. 2 database softwares > > > > > > > > > Hi! > > > > > > I found that PHP can be compiled and work with only one database > > > software. You won't be able to have PHP to work with 2 seperate > database > > > softwares. (You can compile it but it will work only with one databse > > > software, not both, no matter what). I checked the php "./configure" > file > > > and found that it is not design to include 2 seperate > databases when you > > > want it to. > > > > > > Man, it would be very nice to have PHP to work with multiple > database > > > softwares. The only way you can have PHP to work with more than > > > 1 database > > > softwares, then you would need to compile PHP & Apache to > work with one > > > database. Then re-configure and re-compile PHP & Apache to a seperate > > > directory. That way, you will have 2 apaches and run them > > > together. There > > > is no other way! > > > > > > Thanks, > > > Scott > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP vs. 2 database softwares
> -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 11:11 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP vs. 2 database softwares > > > I found that PHP can be compiled and work with only one > database software. You won't be able to have PHP to work > with 2 seperate database softwares. (You can compile it > but it will work only with one databse software, not both, > no matter what). For the record, I've successfully built PHP to work with MySQL, Informix, and Sybase/MSSQL and am able to successfully use all three -- even within the same script when it's called for. What's the error message you get when you try to build with multiple DB's supported? --- Mark Roedel | "Blessed is he who has learned to laugh Systems Programmer| at himself, for he shall never cease LeTourneau University | to be entertained." Longview, Texas, USA | -- John Powell -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP vs. 2 database softwares
Do you meant to say that it took me several days to figure out that PHP doesn't support multiple databases? PHP said it will work with almost any databases but it failed to meant to say that only "with" one databases, but not multiple databases at the same time. Scott "Andrew Hill" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Scott, > > That is what ODBC is for. > Compile --with-iodbc as per the howto at www.iodbc.org > and you can use ODBC drivers for multiple database platforms at the same > time. > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Data Integration Technology Providers > > > -Original Message- > > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 01, 2001 12:11 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] PHP vs. 2 database softwares > > > > > > Hi! > > > > I found that PHP can be compiled and work with only one database > > software. You won't be able to have PHP to work with 2 seperate database > > softwares. (You can compile it but it will work only with one databse > > software, not both, no matter what). I checked the php "./configure" file > > and found that it is not design to include 2 seperate databases when you > > want it to. > > > > Man, it would be very nice to have PHP to work with multiple database > > softwares. The only way you can have PHP to work with more than > > 1 database > > softwares, then you would need to compile PHP & Apache to work with one > > database. Then re-configure and re-compile PHP & Apache to a seperate > > directory. That way, you will have 2 apaches and run them > > together. There > > is no other way! > > > > Thanks, > > Scott > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP vs. 2 database softwares
Scott, That is what ODBC is for. Compile --with-iodbc as per the howto at www.iodbc.org and you can use ODBC drivers for multiple database platforms at the same time. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:11 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP vs. 2 database softwares > > > Hi! > > I found that PHP can be compiled and work with only one database > software. You won't be able to have PHP to work with 2 seperate database > softwares. (You can compile it but it will work only with one databse > software, not both, no matter what). I checked the php "./configure" file > and found that it is not design to include 2 seperate databases when you > want it to. > > Man, it would be very nice to have PHP to work with multiple database > softwares. The only way you can have PHP to work with more than > 1 database > softwares, then you would need to compile PHP & Apache to work with one > database. Then re-configure and re-compile PHP & Apache to a seperate > directory. That way, you will have 2 apaches and run them > together. There > is no other way! > > Thanks, > Scott > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP vs. 2 database softwares
Hi! I found that PHP can be compiled and work with only one database software. You won't be able to have PHP to work with 2 seperate database softwares. (You can compile it but it will work only with one databse software, not both, no matter what). I checked the php "./configure" file and found that it is not design to include 2 seperate databases when you want it to. Man, it would be very nice to have PHP to work with multiple database softwares. The only way you can have PHP to work with more than 1 database softwares, then you would need to compile PHP & Apache to work with one database. Then re-configure and re-compile PHP & Apache to a seperate directory. That way, you will have 2 apaches and run them together. There is no other way! Thanks, Scott -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]