conn.BeginTrans generates an Error.

Results 1 to 2 of 2

Thread: conn.BeginTrans generates an Error.

  1. #1
    Snehal Shah Guest

    Default conn.BeginTrans generates an Error.

    Hi.<BR>I have processing asp page in which I have delete, insert and update query. So I have tried to use conn.BeginTrans, conn.CommitTrans and RollbackTrans. I have On Error Resume Next at the start of page. Error Handler is in another file. If Error occurs, I rollback the transaction. So my code starts like this.<BR><BR>conn.BeginTrans<BR>If Err.Number &#060;&#062; 0 then<BR> DisplayError arguments to function.<BR>End if<BR><BR>strSQL = "delete from abc where xyz = 123"<BR>conn.Execute strSQL <BR>If Err.Number &#060;&#062; 0 then<BR> DisplayError arguments to function.<BR>End if<BR><BR>But, BeginTrans gives me error and I could not figure out the reason why ?<BR><BR>I would really appreciate any help.<BR><BR>thanks<BR>Snehal

  2. #2
    ActiveALLI Guest

    Default RE: conn.BeginTrans generates an Error.

    try <BR><BR>conn.BeginTrans()<BR><BR><BR>;o)<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts