RE: [PHP-WIN] Still having a nightmare, Oracle and PHP

That was me, and it didn't work... --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Caesar si viveret, ad remum dareris. > -----Original Message----- > From: Hélio Silva [mailto:helio@helio.com.br] > Sent: Thursday, November 16, 2000 5:18 PM > To: Asendorf, John > Subject: RE: [PHP-WIN] Still having a nightmare, Oracle and PHP > > > I saw this problem before, it was something on Oracle and one > DBA solved! I not shure about what really happened. > > > > > At 13:11 16/11/00 -0500, you wrote: > >OK, I had our network administrator do that, but it still seems to be > >causing me a problem. > > > >The actual error message is: > > > >PHP has encountered an Access Violation at 604B0AE1 > >Warning: failed to rollback outstanding transactions!: ORA-03114: not > >connected to ORACLE in > D:\directory\cc_res_search\res_search.php on line 0 > > > >I'm using OCIPLogon and Logoff in my script and NEVER do I > do anything > >besides a SELECT statement. So I'm not really sure what it > expects to have > >rolledback... > > > >When I use ocilogon, it works flawlessly, but it takes > FOREVER (15 - 20 > >seconds) to get my search results back... > > > >I'm wondering if it has something to do with having the form > and the search > >occuring on the same page. (using an if statement to decide > whether to > >parse the keywords or put out a form) > > > >The code is very long, but the highlights are: > > > ><?PHP > >//testing persistent logon > >echo "DEBUG:--->connecting oracle"; > >echo "DEBUG:--11111--------------------------<>"; > >//$connection=ocilogon("inet","inet","orcl"); > >$connection = OCIPLogon("inet","inet","orcl"); > > > >if (!$connection){ > >echo "DEBUG:------2222----------------------<>"; > >echo OCIError($connection).":".OCIError($connection).""; > >exit; > >} > > > >if (isset ($some_keywords) ) { > > > >//blah blah blah, make SQL select statement from boolean stuff > > > > echo "<br />SQL: $sql"; > > echo "<br />"; > > $stmt = OCIParse($connection,$sql); > > // $stmt now contains a statement handle which is ready to execute > >(prepped) > > > > OCIExecute($stmt, OCI_DEFAULT); > > // $stmt now contains a statement handle which POINTS to a > recordset > > // OCI_DEFAULT denotes default cursor type > > echo "<table border=\"1\">\n"; > > while (OCIFetchInto($stmt, $row, OCI_ASSOC)) { > > // FetchInto fetches directly into a record array and > > // OCI_ASSOC makes that array associative by > the field names > > $res_date = $row[RES_DATE]; > > > > $description = $row[DESCRIPTION]; > > $page = $row[PAGE]; > > $book = $row[BOOK]; > > echo "<tr><td nowrap > > >>valign=\"top\">$res_date</td><td>&nbsp;</td><td><a > >href=\"$book-$page.pdf\">$description</a></td></tr>\n"; > > } > > echo "</table>"; > > echo "\n<br /><a href=\"res_search.php\">New > > Search</a>"; > > echo "DEBUG:LOGGING OFF -------------->"; > > OCILogoff($connection); > > > >} > > > >else { > > > >//make a form that points back to this page with a keywords in it > > > >} > > > >?> > > > >Thanks in advance everyone > > > >--------------------- > >Founder of > >The 'What Kind of Idiot Uses PHP with IIS with Oracle on > NT?' Consortium > > > >Members: John Asendorf, Thomas Kryger, Florian Clever, Ron Woods, Bod > > > >John Asendorf - jasendorf@lcounty.com > >Web Applications Developer > >http://www.lcounty.com - NEW FEATURES ADDED DAILY! > >Licking County, Ohio, USA > >740-349-3631 > > > >Caesar si viveret, ad remum dareris. > > > > > > > > > >> -----Original Message----- > >> From: Hélio Silva [mailto:helio@helio.com.br] > >> Sent: Tuesday, November 14, 2000 11:33 AM > >> To: Asendorf, John; Php-Windows (E-mail) > >> Subject: Re: [PHP-WIN] Still having a nightmare, Oracle and PHP > >> > >> > >> It 's easy. > >> > >> Your IIS_usr doesn't have read access rights to you > >> <oracle_home>\oracle\bin. > >> It ís necessary in order to php_oci8.dll requests oracle.exe. > >> > >> At 09:05 14/11/00 -0500, Asendorf, John wrote: > >> >PHP 4.0.3 as ISAPI IIS4 NT4 Oracle Client 8.1.6 > >> Oracle backend 7.3.4 > >> > > >> > > >> >Is anyone else having problems with OCIPLogon? Does > >> OCIPLogon work with an > >> >8.1.6 client and a 7.3.4 database? I keep getting this > damned Access > >> >Violation ("PHP has encountered an Access Violation at > >> 604B0AE1"). What's > >> >really weird is that it works and it works and then after a > >> while (I'll time > >> >it next time) it just dies. The server keeps working, but I > >> can't get back > >> >on to Oracle until after a server reboot. > >> > > >> >Anyone? > >> > > >> >--------------------- > >> >Founder of > >> >The 'What Kind of Idiot Uses PHP with IIS with Oracle on > >> NT?' Consortium > >> > > >> >Members: John Asendorf, Thomas Kryger, Florian Clever, Ron Woods > >> > > >> >John Asendorf - jasendorf@lcounty.com > >> >Web Applications Developer > >> >http://www.lcounty.com - NEW FEATURES ADDED DAILY! > >> >Licking County, Ohio, USA > >> >740-349-3631 > >> > >> Regards, > >> > >> Hélio S. Silva > >> Guia do Bairro : http://www.guiadobairro.com.br > >> Uso Linux : http://www2.uol.com.br/info/aberto/linux > >> Sao Paulo,SP - BRASIL helio@helio.com.br - Tel +55 11 > >> 9999-2889 > >> > >> > >> -- > >> PHP Windows Mailing List (http://www.php.net/) > >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > >> For additional commands, e-mail: php-windows-help@lists.php.net > >> To contact the list administrators, e-mail: > >> php-list-admin@lists.php.net > >> > > > >-- > >PHP Windows Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > >For additional commands, e-mail: php-windows-help@lists.php.net > >To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > Regards, > > Hélio S. Silva > Guia do Bairro : http://www.guiadobairro.com.br > Uso Linux : http://www2.uol.com.br/info/aberto/linux > Sao Paulo,SP - BRASIL helio@helio.com.br - Tel +55 11 > 9999-2889 >