Re: PEAR::DB with oracle

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. -- James 'Chip' Kaufman jkaufman@wamnet.com 651-256-5137 PGP key: 697D43DE