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