Rollback

• anakin

  SSC Veteran

  Points: 272

  More actions

  July 22, 2002 at 7:42 am

  #78545

  Here is my vb.net code, this code is in an .aspx page.

  Dim objDbConn As New SqlConnection(ConfigurationSettings.AppSettings("strConnEnterprise"))

  objDbConn.Open()

  Dim objCommand As New SqlCommand()

  Dim objTransaction As SqlTransaction

  objCommand.Connection = objDbConn

  objTransaction = objDbConn.BeginTransaction

  objCommand.Transaction = objTransaction

  strSQL = "CREATE TABLE Prova (OID int IDENTITY(1, 1) PRIMARY KEY CLUSTERED, OID_tbBaseProducts int NOT NULL REFERENCES tbBaseProducts(OID))"

  objCommand.CommandText = strSQL

  Dim s As Integer

  Try

  s = objCommand.ExecuteNonQuery()

  objTransaction.Commit()

  Catch ex As SqlException

  objTransaction.Rollback()

  Finally

  objDbConn.Close()

  End Try

  If table Prova exists in my SQL-server archive transaction's roolback raise an exception :

  "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"

  but BEGIN TRANSACTION exists in my code.

  What's the solution of the problem ?

  Thank's anakin

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 22, 2002 at 4:57 pm

  #433199

  Please don't cross post.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter