Sporadic connect failures to Oracle
- From: Frank Burleigh <burleigh@xxxxxxxxxxx>
- Date: Mon, 21 Jan 2008 16:33:51 -0500
I thought I knew how to do this. But one, low-use web form occasionally loses form submissions and I haven't been able to understand why. I can't even duplicate the behavior.
The form's processor is in a JSCRIPT "class" so I'll pull out the relevant bits below.
Several users report seeing the "cannot save" message "thrown" when the test for this.aConnection.State!=1 fails.
No other place in the application presents that error, so I'd guess that's the problem: either the test itself is invalid, or we're really having trouble making connections.
Hints would sure be appreciated.
this.aConnection=null;
var sConnect="Provider=OraOLEDB.Oracle;Data Source=<>;User Id=<>;Password=<>";
this.aConnection=Server.CreateObject( "ADODB.Connection" );
if( !this.aConnection )
throw "The application cannot access information.";
this.aConnection.Open( sConnect );
if( this.aConnection.State!=1 )
throw "The application cannot save your submission.";
this.aConnection.Execute( <insert DDL to add a record>, 0, 1 );
this.aConnection.Close();
.
- Prev by Date: retain user rights
- Next by Date: Re: retain user rights
- Previous by thread: retain user rights
- Next by thread: Urgent problem about SQL Server
- Index(es):