Connection is already part of a local or a distributed transaction连接已经是本地或分布式事务一部分
最好不要用关键字CONNECTION,以下是我用的: dim myConn as sqlConnection=New sqlConnection(strConn) dim myCMD as sqlCommand =New sqlCommand() dim myTrans as sqlTransaction . . . try myConn.open() myTrans=myConn.beginTransaction() myCMD.transaction=myTrans myCMD.connection=myConn . . . myTrans.commit() catch myTrans.rollBack() finally myConn.close() end try
dim myConn as sqlConnection=New sqlConnection(strConn)
dim myCMD as sqlCommand =New sqlCommand()
dim myTrans as sqlTransaction
.
.
.
try
myConn.open()
myTrans=myConn.beginTransaction()
myCMD.transaction=myTrans
myCMD.connection=myConn
.
.
.
myTrans.commit()
catch
myTrans.rollBack()
finally
myConn.close()
end try