Windows error 0x8004D00A, -2147168246

Detailed Error Information

XACT_E_NOENLIST[1]

MessageUnable to enlist in the transaction.
Declared inwinerror.h

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode4 (0x004)
NameFACILITY_ITF[2][1]
DescriptionThe source of the error code is COM/OLE Interface management.[2][1]
Error Code53258 (0xd00a)

Questions

5votes
1answer

Intermittent failure to enlist SSIS package in DTC transaction

Our packages are randomly failing with the following error message: > SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8004D00A. COM error object information is available. Source: "[Some Package Name]" error code: 0x8004D00A Description: "The SSIS Runtime has failed to enlist the OLE DB connection in [...] read more
ssis
msdtc
1vote
1answer

VB.NET DataSet not working with view with linked SQL Server

I am in DataGrid hell right now but that's another post. Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server. Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with [...] read more
sql-server
vb.net
odbc
odbc-sql-server-driver
0votes
2answers

Distributed Transactions between MSSQL 2000 & MySQL Stopped Working

We have been successfully copying data from a MySQL Slave database into a MSSQL database. The MySQL server is a linked server. I have tried using v3.51 and v5.1.8 of the ODBC connector provided my MySQL. Simply trying to insert into a temporary table in MSSQL from a table in [...] read more
mysql
sql-server
transactions
0votes
1answer

Business Objects XI performing DISTRIBUTED TRANSACTION by default-How to turn off?

I have a Business Objects Web Intelligence report that is performing a distributed query against two databases. When I run this query that includes a BEGIN DISTRIBUTED TRANSACTION QUERY SET xact_abort ON GO USE Pipeline2 GO BEGIN DISTRIBUTED TRANSACTION SELECT * FROM [CQSR_PROD].CqUSer.Cq4User1.Defect COMMIT TRAN GO I get this error: [...] read more
sql-server
business-objects

Comments

Leave a comment

(plain text only)

Sources

  1. winerror.h from Windows SDK 10.0.14393.0
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx

User contributions licensed under CC BY-SA 3.0