Re: PEAR::DB with oracle

Thanks for the tip James. I changed it and it seems to be working fine. I'll continue to use it this way and see if it stays 'stable'. I would guess this is a problem on DB's side of the connection because when I originally used Oracle connections I was using regular php functions to connect and do work and I always used a persistant connection with no problems. Do you think by turning of the persistant connection that my tools will be less efficient or become slower? I'm going to play around with it to see if our Admin will call me up and tell me to quit what I'm doing :) haha... Thanks again! Abe Music James 'Chip' Kaufman wrote: > On Tuesday 22 July 2003 10:22, Abe Music wrote: >> Hi, >> >> I've been using DB for awhile now and it's always been with mysql. >> Now, I have branched out and I am now using DB to connect to our >> university's major databases as well as local mysql db's too. Our >> university has two major db's that we use and I often make >> connections to both as well as a mysql database. >> >> Here's the code: >> >> function db1_connect() { >> $dsn = array ( >> 'phptype' => 'oci8', >> 'username' => '********', >> 'password' => '********', >> 'hostspec' => '********'); >> >> $options = array ('persistent' => TRUE, 'optimize' => >> 'portability'); >> >> $dbh = DB::connect($dsn,$options); >> return $dbh; >> } >> >> >> Can anyone please help me? If I don't get this fixed I'm going to be >> forced to move to another abstraction layer instead of DB to get my >> tools up and running smoothly. >> >> Thanks! > > Have you tried setting 'persistent' to 'false'? I had some issues with > an Informix database that I fixed this way. >