Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Tough problem? Rolling back timed out Stored Procedure called from ASP?

Reply
Thread Tools

Tough problem? Rolling back timed out Stored Procedure called from ASP?

 
 
M Wells
Guest
Posts: n/a
 
      03-03-2004
Hi All,

I don't know if this is a truly esoteric question, or not, but I'm
wondering how (or even if) you handle a timeout on a transaction
within a stored procedure executed in a Stored Procedure?

A theoretical example of the stored procedure (sadly, I'm not allowed
to post the actual code):


Create proc sp_testproc @myval int, @outval int OUTPUT as

begin tran

select top 1 @outval= myname from mytable where recid = @myval

update mytable set myname='xxxx' where recid = @myval

commit

select @outval


So, again in theory, I'm executing this stored procedure from an ASP
page.

After executing the stored procedure, I'm testing the ADO connection's
error object for a timeout.

What I'd like to know, is that if the stored procedure times out (ie
ADO.Error.Number = -2147217871) and I issue an ADO.RollbackTrans in
response to that error, will that rollback the transaction contained
within the Stored Procedure?

Many, many, many thanks in advance for any help with this!!

Much warmth,

Murray
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Char(1) can't be insert from stored procedure called from C#/ASP.n JB ASP .Net 2 03-05-2010 08:23 AM
'Procedure or function <stored procedure name> has too many arguments specified',,,ARGH! Mike P ASP .Net 0 06-19-2006 01:19 PM
System.Web.HttpException: Request timed out - [HttpException (0x80004005): Request timed out.] Steve ASP .Net 0 07-01-2003 12:11 AM
Called a Stored Procedure , decimal parameter Mona ASP .Net 1 06-27-2003 02:08 PM
Called a Stored Procedure , decimal parameter Mona ASP .Net Web Controls 0 06-27-2003 11:16 AM



Advertisments