//  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 80040E21 errors?


Why do I get 80040E21 errors?

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'  
ODBC driver does not support the requested properties.
 
This can happen if you use an adOpenStatic ADODB.Recordset object to open Excel, or use an adOpenKeyset recordset to perform paging,  
 
Basically, make sure the methods/properties you are using are supported by the driver/provider you are using to access your data. 
 
If you are executing a stored procedure, make sure you do so through the connection.execute() method, rather than a command object, and add the following two lines of code to the beginning of your procedure: 
 
SET ANSI_NULLS OFF 
SET NOCOUNT ON
 
If you are using With, an ADODB.Recordset, and the AddNew/Update methodology, consider not doing so (see Article #2191) and, failing that, see KB #228935
 
If you are sure that these things are intact, make sure you have the latest version of MDAC (MDAC Download Page). 
 

 
Microsoft OLE DB Provider for SQL Server error '80040e21' 
Optional feature not implemented. 
 
or 
 
ADOBD Parameter error '800a0d5d' 
The application is using a value of the wrong type for 
the current operation.
 
This can often be caused by using invalid ad* constants with ADODB.Command, such as adDBDate. Use adDBTimeStamp instead (see KB #214459) or, better yet, use a straight EXEC statement instead of using the command object at all (see Article #2201). 
 

 
Microsoft JET Database Engine error '80040e21'  
Cannot include Memo, OLE, or Hyperlink Object when you select unique values (<column(s)>).
 
This error is pretty explanatory. Access does not allow these 'special' columns to be included in DISTINCT queries. So if you have the following code, where bar is a memo column: 
 
SELECT DISTINCT foo, bar FROM table
 
You could change it to the following to alleviate the error: 
 
SELECT foo, bar FROM table GROUP BY foo, bar
 
Though I have always questioned why you would have duplicates in a memo column; since it is designed to store a LOT of text, it seems that in most scenarios it would be unlikely to repeat enough, and also be insignificant in terms of individual records? 
 

 
Microsoft OLE DB Provider for SQL Server error '80040e21' 
Invalid character value for cast specification.
 
This can happen if you try and pass a NULL string or a non-string datatype to an ADODB.Recordset object or a stored procedure, and the database logic attempts to perform an implict or explicit CONVERT or CAST.  
 

 
Microsoft JET Database Engine error '80040e21' 
You tried to execute a query that does not include the specified expression 
'<column>' as part of an aggregate function.
 
If you are using an aggregate function (e.g. SUM, COUNT, MAX), then any other column in the SELECT list must also be in the GROUP BY clause. This is so that the database knows how to organize results. 
 

 
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)  
Multiple-step OLE DB operation generated errors. Check each OLE  
DB status value, if available. No work was done.
 
For full information on this error message, see Article #2288.

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 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 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: 8/15/2002 | Last Updated: 11/14/2003 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (149)

 

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