3 Replies Latest reply: Mar 2, 2010 12:38 PM by gdarling - oracle RSS

    Unable to enlist in a distributed transaction

    755336
      Hi,
      im using vs2008 with oracle 11g
      and im using TransactionScopes
      ex:

      (using TransactionScope Scope = new TransactionScope ())
      {
      Connection.Open();
      ..........
      Connection.Close()//Here i get the error
      }

      on XP windows everything work just fine,


      but on Windows 7 on Connection.Close()
      i keep getting this error
      System.Exception: Unable to enlist in a distributed transaction

      i don't know if here is the right place to post thsi question :)

      can anyone help me on this??
      thank u in advance
        • 1. Re: Unable to enlist in a distributed transaction
          gdarling - oracle
          Oracle currently has no supported software for Windows 7.

          For Windows 7 support information refer to the following notes on My Oracle Support:

          Statement of Direction: Oracle Database 10g Release 2 (10.2.0.5) Client on Microsoft Windows 7 and Microsoft Windows Server 2008 R2
          Read My Oracle Support Note 1061272.1 to learn about Oracle Database Client 10.2.0.5 planned support for Windows 7 and Windows Server 2008 R2.

          Statement of Direction: Oracle Database 11g Release 2 on Microsoft Windows 7 and Microsoft Windows Server 2008 R2
          Read My Oracle Support Note 867040.1 to learn about Oracle Database's planned support for Windows 7 and Windows Server 2008 R2.


          The best I can suggest is to test again once a version supported on Win7 is available.

          I would suggest that you check to make sure the Oracle Services for Microsoft Transaction Server component is installed on the Oracle client though just to suggest the obvious. It doesnt get installed with all install types.

          Hope it helps,
          Greg

          Edited by: gdarling on Mar 2, 2010 11:18 AM
          • 2. Re: Unable to enlist in a distributed transaction
            755336
            thank u for your help
            but can you tell me when 11.2 version will be released??
            and how i check the Oracle Services for Microsoft Transaction Server component is installed??

            thank you again for your help.
            • 3. Re: Unable to enlist in a distributed transaction
              gdarling - oracle
              Hi,

              To see if you have Oracle Services for MTS installed, open the Oracle Universal Installer, click the Installed Products button.

              You can also "shortcut" check by checking your OracleHome\bin directory to see if it contains oramts11.dll and oramtsreco.exe

              Cheers,
              Greg