error message help needed

[TJS]

how to resolve this ?

error msg:
=================
"System.Data.SqlClient.SqlException: Distributed transaction completed.
Either enlist this session in a new transaction or the NULL transaction."
code:
===========
....
myConnection.Open()
Dim tran As SqlTransaction = myConnection.BeginTransaction()
Try
tran = myConnection.BeginTransaction()
cmdInsert.Transaction = tran
cmdInsert.ExecuteNonQuery()
tran.Commit()
Catch ex as Exception
tran.Rollback()
Finally
myConnection.Close()
....

[vijay]

try
SqlTransaction = Nothing (or) null

at the end of ur transaction

"TJS" <no****@here.com> wrote in message news:<eb**************@TK2MSFTNGP12.phx.gbl>...

how to resolve this ?

error msg:
=================
"System.Data.SqlClient.SqlException: Distributed transaction completed.
Either enlist this session in a new transaction or the NULL transaction."
code:
===========
...
myConnection.Open()
Dim tran As SqlTransaction = myConnection.BeginTransaction()
Try
tran = myConnection.BeginTransaction()
cmdInsert.Transaction = tran
cmdInsert.ExecuteNonQuery()
tran.Commit()
Catch ex as Exception
tran.Rollback()
Finally
myConnection.Close()
...