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 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]




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 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 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 Andrew Hill

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]