RE: [PHP-WIN] Oracle Persistent Logon - Error Will Robinson!!! ! Evil Access Violation.

The ORA-03114 error is Oracle's way of telling you that you are not connected to Oracle. I this case, I suspect it may be a bogus error since you encountered the infamous NT access error. Try granting read access to the IIS_USR to the oralce\bin directory. It appears the php oracle dll may be trying to use something in that directory. As far as the rollback message is concerned. Since you are using a persistent connection the Oracle transaction starts when you initiate the PLogin and remains until you logout or commit. If the session was open from a previous web request and the transaction aborts Oracle lets you know a rollback was attempted. It appears that in this case, unsuccessfully. Ron Woods/GAI Sr. Software Engineer 1777 N.E. Loop 410 Suite 600 San Antonio, TX 78217 Tel: 210-820-2615 Fax: 210-832-0487 http://www.gai-inc.com -----Original Message----- From: Asendorf, John [mailto:JAsendorf@lcounty.com] Sent: Thursday, November 02, 2000 3:31 PM To: Php-Windows (E-mail) Subject: [PHP-WIN] 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 > -- 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