2 Replies Latest reply: Oct 2, 2012 6:16 PM by 965758 RSS

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

    848531
      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
          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
            Could please let me know how you resolved it?