//  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 800A0E78 errors?


Why do I get 800A0E78 errors?

I think we've all seen this one before: 
 
ADODB.Connection error '800a0e78'  
Operation is not allowed when the object is closed.  
/<file>.asp, line <line>
 
In older versions of MDAC, the error might be slightly different: 
 
The operation requested by the application is not allowed if the object is closed.
 
This error can be caused when you try to access values from an empty recordset or from a recordset that has already been closed. The most common cause, however, seems to stem from calling a stored procedure that does not use SET NOCOUNT ON. See Article #2275 for more info. 
 
A nearly identical, but far less common message: 
 
ADODB.Recordset error '800a0e79'  
Operation is not allowed when the object is open. 
/<file>.asp, line <line>
 
This can be caused by trying to set a property that needs to be set before the object is opened. For example, trying to set the MaxRecords property of an ADODB.Recordset object after opening the recordset: 
 
<% 
    set rs = CreateObject("ADODB.Recordset") 
    rs.open "SELECT columns FROM tablename",conn 
    rs.maxRecords = 5 
%>
 
To fix, the code should be: 
 
<% 
    set rs = CreateObject("ADODB.Recordset") 
    rs.maxRecords = 5 
    rs.open "SELECT columns FROM tablename",conn 
%>
 
You might also get 800a0e78 errors from the provider, without much more useful information. If this happens when attempting to connect to the database, please review Article #2126 and compare your connection string to the recommended formats listed.

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 8004D00A 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 800A0E7C errors?
Why do I get 800A0E7D errors?
80004005 Errors
Can I use the NZ() function without getting 80040E14 errors?

 

 


Created: 6/27/2002 | Last Updated: 3/24/2005 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (129)

 

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