Author: safzal1212 | Posted on: 8/28/2009 9:20:02 AM | Views : 266

I am trying to insert data in two different databases on different server in a single transaction. I am using TransactionScope for this pupose but when I try to open second connection it gives me error "Communication with the underlying transaction manager has failed." DTC is configured and working on the server. Any help would be appreciated. I am using the follwoin method
Public Sub InsertStatus(ByVal strStatusName As String) Dim options As New TransactionOptions options.IsolationLevel = Transactions.IsolationLevel.ReadCommitted options.Timeout = New TimeSpan(0, 2, 0) Using scope As New TransactionScope(TransactionScopeOption.Required, options) Using cnConn As New SqlConnection(cnString) Using cmdCommand As New SqlCommand() cmdCommand.CommandText = "usp_InsertStatus" cmdCommand.CommandType = CommandType.S ...

Go to the complete details ...