//  home   //  advanced search   //  news   //  categories   //  sql build chart   //  downloads   //  statistics
 ASP FAQ 
Home
ASP FAQ Tutorials

   8000XXXX Errors
   Alerts
   ASP.NET 2.0
   Classic ASP 1.0
   Databases
   General Concepts
   Search Engine Optimization (SEO)

Contact Us
Site Map

Search

Web
aspfaq.com
tutorials.aspfaq.com

ASP FAQ Tutorials :: 8000XXXX Errors :: Why do I get 8004D00A errors?


Why do I get 8004D00A errors?

SQL Server 
 
Microsoft OLE DB Provider for SQL Server error '8004d00a'  
Distributed transaction error
 
This can happen if you use the following line in your ASP code, and then connect to SQL Server: 
 
<%@TRANSACTION=Required%>
 
My first recommendation is to handle transactions at the database level. 
 
If you absolutely must use Transaction Server (MTS) to handle ADO transactions from within ASP, you need to make sure the distributed transaction coordinator (DTC) is configured correctly. The web server and the SQL Server must be able to see each other over the network, by name. For more information on configuring MTS for use with DTC and SQL Server, see KB #191168. There is also a new KB article written by an ASP.NET MVP: KB #555017
 
And finally, be sure to use an OLE-DB connection string, as opposed to ODBC (see Article #2126). 
 

Oracle 
 
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a' 
[Microsoft][ODBC driver for Oracle]Failure enlisting in Resource Manager 
 
or 
 
Provider error '8000ffff' 
Catastrophic failure
 
This might mean that the resource DB list has become corrupted. You can try reinstalling the driver you're using, reinstalling ODBC, or getting an OLE-DB driver (see Article #2126). Make sure that if you are using a linked server from SQL Server to Oracle, and connecting from ASP through the linked server, that you have the linked server set up correctly (see KB #280106). 
 
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a' 
[Oracle][ODBC]Driver not capable.
 
Make sure that your Oracle client is 8.0.5.2.2 or higher, and see the white paper on configuring MTS with Oracle, from KB #193893.

Related Articles

Why do I get 8002000A errors?
Why do I get 80040200 / 80040514 / 800A0E7A errors?
Why do I get 80040e09 errors?
Why do I get 80040E0C errors?
Why do I get 80040E10 errors?
Why do I get 80040E14 errors?
Why do I get 80040E21 errors?
Why do I get 80040E23 errors?
Why do I get 80040E24 errors?
Why do I get 80040E2F errors?
Why do I get 80040e30 errors?
Why do I get 80040E31 errors?
Why do I get 80040E37 errors?
Why do I get 80040e4e errors?
Why do I get 80040E54 errors?
Why do I get 80040E57 / 80040E07 errors?
Why do I get 80070070 errors?
Why do I get 800A01FB errors?
Why do I get 800A0BB9 / 800A1391 errors?
Why do I get 800A0C93 errors?
Why do I get 800a0cb3 errors?
Why do I get 800A0CC1 errors?
Why do I get 800A0E78 errors?
Why do I get 800A0E7C errors?
Why do I get 800A0E7D errors?
80004005 Errors
Can I use the NZ() function without getting 80040E14 errors?

 

 


Created: 12/11/2003 | Last Updated: 12/12/2003 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (215)

 

Copyright 1999-2006, All rights reserved.
Finding content
Finding content.  An error has occured...