Hi,
I am running into an issue when I open a distributed transaction and enlist SQL server and Oracle server connection to it. SQL passes fine but Oracle gives me an following error :
'The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)
I have tried everything I found on the net for configuring MSDTC properly. No luck yet.
HEre is my code snippet:
Dim trans As New CommittableTransaction
Try
'' Set the ambient transaction.
Transaction.Current = trans
oSLConn.EnlistTransaction(trans)
oRelConn.EnlistTransaction(trans) '''' Code fails here and throws above error.
''' DO other stuff.....
trans.Commit()
Catch tex As TransactionAbortedException
trans.Rollback()
oLog.WriteLog(tex.Message & Environment.NewLine & tex.StackTrace, clsLog.LogLevel.LOGERROR)
Catch ex As Exception
trans.Rollback()
oLog.WriteLog("Error while processing verified transactions: " & ex.Message, clsLog.LogLevel.LOGERROR)
Finally
''' Clean up
End Try
I am running into an issue when I open a distributed transaction and enlist SQL server and Oracle server connection to it. SQL passes fine but Oracle gives me an following error :
'The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)
I have tried everything I found on the net for configuring MSDTC properly. No luck yet.
HEre is my code snippet:
Dim trans As New CommittableTransaction
Try
'' Set the ambient transaction.
Transaction.Current = trans
oSLConn.EnlistTransaction(trans)
oRelConn.EnlistTransaction(trans) '''' Code fails here and throws above error.
''' DO other stuff.....
trans.Commit()
Catch tex As TransactionAbortedException
trans.Rollback()
oLog.WriteLog(tex.Message & Environment.NewLine & tex.StackTrace, clsLog.LogLevel.LOGERROR)
Catch ex As Exception
trans.Rollback()
oLog.WriteLog("Error while processing verified transactions: " & ex.Message, clsLog.LogLevel.LOGERROR)
Finally
''' Clean up
End Try