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 ...