This discussion is archived
3 Replies Latest reply: Mar 2, 2010 10:38 AM by gdarling - oracle RSS

Unable to enlist in a distributed transaction

755336 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

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