Oracle Persistent Logon - Error Will Robinson!!!! Evil Access Violation.

IIS 4, NT 4, Oracle Client 8.1.6, Oracle Server 7.3.4, PHP 4.03 (from php4win) OK, new problem with the same monster... Anyone know what this means? PHP has encountered an Access Violation at 604B0AE1 Warning: failed to rollback outstanding transactions!: ORA-03114: not connected to ORACLE in D:\thepath\cc_res_search\res_search.php on line 0 What is weird about this is that the ONLY SQL statement is a SELECT statement... how/why would there even be a rollback possibility? Using OCIPLogon. --------------------- 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 > -----Original Message----- > From: Asendorf, John [mailto:JAsendorf@lcounty.com] > Sent: Thursday, November 02, 2000 11:11 AM > To: Php-Windows (E-mail) > Subject: [PHP-WIN] Oracle Persistent Logon - Question about > Logging off > > > I've greatly increased the search speed of a search utility > I'm using in > Oracle by using OCIPLogon... it's lightning now! BUT > > I'm not sure if the webserver is ever logging off of the > database... (this > will be a problem during our DLT backups every night...) how > can I check? > I have a line that runs an OCILogoff on the connection, but > the next search > screen doesn't take nearly as long to log on... > > Order of events: > > Added OCIPLogon to search form page (which is the same as the > search results > page) > -----logon took a while > > Ran the search and got the results back almost immediately > > went back to the search form page > -----logon took almost no time (yes I cleared the cache on my > local machine) > > ---------- > > So I'm just worried about the webserver ALWAYS being connected to this > database and am not sure how to check if the connection is > ending after the > end of the search... > > > Thanks in advanve, > > John > --------------------- > 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 > > > > -- > 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 >