Re: [PHP-DB] PHP vs. 2 database softwares

2001-10-02 Thread Andreas Karajannis

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

2001-10-01 Thread Scott Fletcher

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

2001-10-01 Thread Mark Roedel

 -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

2001-10-01 Thread Andrew Hill

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

2001-10-01 Thread Adi Wibowo


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]