Oracle 10g DTC

From: <leroy_at_benefitsoftware.com>
Date: 10 Jan 2007 10:51:44 -0800
Message-ID: <1168455104.349908.229940@i56g2000hsf.googlegroups.com>

I have an database application that runs COM+ components against MSSQL and Oracle databases and uses Distributed Transaction Coordinator(DTC) to handle transactions.

I have recently set up a new machine with Win2003 and Oracle 10G. When my application attempts to access the database, I get a error "Cannot connect to the transaction manager or the transaction manager is unavailable".

I installed Oracle MTS as part to the client install and the Oracle MTS Recovery Service is started. I also examined the registry and edited the following as recommended.

[HKEY_LOCAL_MACHINE\SOFTWARE

         \Microsoft\MSDTC\MTxOCI]


         "OracleXaLib"="oraclient10.dll"

         "OracleSqlLib"="orasql10.dll"

         "OracleOciLib"="oci.dll"

The MsDtcOra test utility fails when attempting to GetProcAddress for 'xaosw' in oraclient10.dll.

Any help or direction would be greatly appreciated.

Leroy Received on Wed Jan 10 2007 - 12:51:44 CST