Transaction Error in VB FOrms app

[ybittu]

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

 

[cjard]

What happens if you use a transactionscope?