XA Transactions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: steffenv (steffenv_at_discussions.microsoft.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 14:29:01 -0700

Hi,

I'm trying to to have SQL Server 2000 participate in a 2PC scenario using
DTC as an XA compliant RM. I can successfully call the xa functions on the
the xa_switch_t struct provided in XaSwitch.Lib. According to the
documentation, after beginning a transaction I have to inform the RM about
the transaction using SQLSetConnectAttr(SQL_ATTR_ENLIST_IN_XA, TRUE, 0).
However, this returns the error 25000 'Illegal operation while in a local
transaction'. If I call it right after establishing the connectiion, I get
HYC00 'Optional feature not implemented' from the driver. Is
SQL_ATTR_ENLIST_IN_XA supported in SQLServer? If so where should I setl it
and if not what other options do I have to use SQL Server in that scenario?

Thanks,
Steffen

Relevant Pages

  • XA Transactions
    ... the transaction using SQLSetConnectAttr. ... HYC00 'Optional feature not implemented' from the driver. ... and if not what other options do I have to use SQL Server in that scenario? ...
    (microsoft.public.data.odbc)
  • Re: leave connections open for how long?
    ... Scenario 1: ... Your application 'talks' to Sql Server on the same machine ... In this case there is never going to be any contention for connection ... Is there any reason other than executing within a transaction to leave a ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Re: Windows Completely Locks Up!! FREEZE
    ... failing to start/run the Distributed Transaction Coordinator. ... Error Specifics: ... The Business Contact Manager SQL Server Startup Service service terminated ... The service did not respond to the start or control request in a timely ...
    (microsoft.public.windowsxp.general)
  • Re: Asynchronous Stored Procedure Never Returns - Help?
    ... If you have the Sql Server 2000 or 2005 docs they are thorough and can be ... for Transaction SQL Reference from the drop-down or select a keyword from ... your query in Query Analyzer or Sql Server Management Studio, ...
    (microsoft.public.dotnet.languages.csharp)