This discussion is archived
2 Replies Latest reply: Oct 2, 2012 4:16 PM by 965758 RSS

Unable to enlist in a distributed transaction (Windows7, Oracle 11G R1)

848531 Newbie
Currently Being Moderated
Hi,
I have a .Net application running on Windows 7 x64 using VisualStudio2008 and Oracle 11G R1 32bit client
In it I call a webservice calling another webservice, this requires to use oramts that interfaces with Microsoft DTC. However I'm getting the following error when calling the service method:
"Unable to enlist in a distributed transaction"

I have checked the following:

- Ora MTS is installed
- DTC is running, the security settings allow AX transactions (in fact I just allowed everything)
- Network services have the permission to access oracle dlls
- The registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI contains the following: "OracleXaLib"="xa80.dll" "OracleSqlLib"="SQLLib80.dll" "OracleOciLib"="oci.dll" (not sure if this is right)

What is it I'm doing wrong ? Does this version of Oracle work correctly on W7 ?

By the way it works fine on Windows XP !

I've spend quite some time trying to find a resolution..

Thanks!
  • 1. Re: Unable to enlist in a distributed transaction (Windows7, Oracle 11G R1)
    848531 Newbie
    Currently Being Moderated
    I think I answered my own question

    It seems that MSDTC is not supported by Oracle 11G R1 on Windows x64 !


    All Oracle Database components are supported on Windows x64 with the following exceptions:

    •Oracle Services for Microsoft Transaction Server are not supported on Windows Vista. As a result, all Oracle Windows data access drivers on Windows Vista that use Oracle Services for Microsoft Transaction Server to enlist in Microsoft Distributed Transaction Coordinator (MSDTC) coordinated transactions cannot participate in those coordinated transactions. These data access drivers include Oracle Data Provider for .NET, Oracle Provider for OLE DB, Oracle Objects for OLE, and ODBC. Check OracleMetaLink for up to date information on Oracle Services for Microsoft Transaction Server certification with Windows Vista.

    http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/reqs.htm#CHDCEFIJ

    Edited by: 845528 on 18 mars 2011 05:05
  • 2. Re: Unable to enlist in a distributed transaction (Windows7, Oracle 11G R1)
    965758 Newbie
    Currently Being Moderated
    Could please let me know how you resolved it?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points