On Tue, 2004-03-30 at 15:34, Lee Brink wrote: > Rafael Martinez Guerrero said: > > We were using oracle with Squirrelmail until january but we are using > > postgreSQL now for saving addressbook/userprefs and sessions (better > > speed and less resources). > > > > I remember we had some problems with apache/php and with SM when using > > oracle. Supposing that you have a working installation of apache/PHP > > w/oracle support, you need to define some env variables in apache > > > Thanks for the information. > > I've been running under the assumption that with SquirrelMail using PEAR I > did not need to build PHP with Oracle support enabled. I do know that > without having Oracle support compiled in there are Oracle specific > commands that would not be available, but looking at the PHP/PEAR > documentation I did not get the impression that I had to have Oracle > support enabled for simple connection and query support. > > So would it be correct for me to now assume that to have any hope of > connecting to an Oracle database in any way I must have the Oracle > libraries installed and Oracle support compiled in? >
Correct. You need the Oracle libraries (client too??) installed and Oracle support compiled in PHP before you can access an Oracle DB from PHP/PEAR. PEAR_DB is only a generic API to access a DB. f.ex. you use connect() from PEAR but internally, PEAR_DB uses pg_pconnect() (for postgres), oci_connect() (for oracle), etc. To compile oracle support into PHP was not trivial when we did it. But it looks like there is more information out there now. http://www.php.net/manual/en/ref.oci8.php Ask if it does not work and I'll try to find the buildlogs for our old system. The rest of the information I sent you in my last email is still valid. > And be gentle to the person asking for what must sound like a boneheaded > question. :) > > Lee I was gentle, didn't I? :) with regards -- Rafael Martinez, <[EMAIL PROTECTED]> Center for Information Technology Services University of Oslo, Norway
signature.asc
Description: This is a digitally signed message part
