Re: distributed transaction problem

From: Steve (pls2917)
Date: 03/09/04

  • Next message: franz: "Re: design pattern" 
    Date: Tue, 9 Mar 2004 16:29:32 -0500

    Mark,

    Thanks for the reply.

    Yes, the middle tier code is a ServicedComponent marked with
    [Transaction(TransactionOption.RequiresNew)]

    I think I found the answer to my problem in the following article:
    http://support.microsoft.com/?id=827805

    However, I wish I knew what holes I was opening by adding that registry key.
    The KB article calls the behavior a bug but it doesn't say if a hotfix is
    available.

    -Steve

    "Mark Jen [MSFT]" <markjen@online.microsoft.com> wrote in message
    news:OZBkLkYBEHA.892@TK2MSFTNGP09.phx.gbl...
    > Hi Steve,
    >
    > Could you give us some more details about your middle tier code? Is it a
    > ServicedComponent? Is it marked with a TransactionAttribute? Are you
    > connecting to SQL with enlist=true in the SQL Connection String or are you
    > using the SqlConnection.EnlistDistributedTransaction method?
    >
    > Thanks,
    > Mark [MSFT]
    > --
    > Please reply in newsgroup.
    > This posting is provided "AS IS" with no warranties, and confers no
    rights.
    >
    > "Steve" <pls2917 at mail.standarddomainsuffix> wrote in message
    > news:eOsKO9UBEHA.688@tk2msftngp13.phx.gbl...
    > > Hi All,
    > >
    > > I'm having a problem running distributed transactions from a middle tier
    > > server to a SQL Server. I'm getting the following error when it
    attempts
    > to
    > > connect to SQL Server inside a transaction:
    > >
    > > [COMException (0x8004d00e): The transaction has already been implicitly
    or
    > > explicitly committed or aborted]
    > >
    > > I've researched other posts on this error and none of the resolutions
    seem
    > > to help in my case. Some additional information:
    > >
    > > 1. All servers are running Windows Server 2003. Database server is SQL
    > > Server 2000.
    > >
    > > 2. Servers are all standalone. No domain involved.
    > >
    > > 3. NetBios name resolution works fine and I verified this using
    > DTCPING.EXE
    > >
    > > 4. I've checked the "Enable Network DTC Access" when adding the
    > application
    > > server to Windows Server 2003 on both computers.
    > >
    > > Any other ideas on things I may have missed?
    > >
    > >
    > >
    >
    >

  • Next message: franz: "Re: design pattern"

    Relevant Pages

    • Re: Windows Integrated Security / SQL 2000 / IIS 5.0 / COM+
      ... Have you added SPN for SQL Server to active directory with setspn? ... > We are in the process of moving away from SQL Std Security ... > => The middle tier COM+ components in turn access a SQL ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server 2005 Memory edition
      ... This is one reason why object relational tools, and middle tier objects ... SQL can come up with prototypes using set processing that c# can't hope ... dollar discount SKU to an order with Product107, if necessary, we ...
      (microsoft.public.sqlserver)
    • Re: how to get both old and new value for a changed text box
      ... Access clients and another for SQL Server clients. ... form sends requests for adding and updating records to the middle tier ... accomodate ANY db this way, ...
      (microsoft.public.dotnet.languages.vb)
    • Re: PL/SQL or SQL in the middle tier?
      ... The database layer would just be a set of ... tables that the middle tier would manipulate with SQL. ... Oracle Ace Director & Instructor ...
      (comp.databases.oracle.server)
    • Re: how to get both old and new value for a changed text box
      ... Access clients and another for SQL Server clients. ... form sends requests for adding and updating records to the middle tier ...
      (microsoft.public.dotnet.languages.vb)