By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,564 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

IErrorInfo.GetDescription failed with E_FAIL(0x80004005) error when calling the Fill method

P: n/a
I am recieving the following error message when I call the Fill() method in
ASP.NET/VB.NET:
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
I have looked for help on this error on the web, and every site I found said
it is caused by using a keyword as a fieldname in my database. However, I
have checked and am pretty sure that none of my fieldnames are keywords.
Here is the SQL statement I am executing (I am using Microsoft Access as my
database):
SELECT headline,url,summary,updated FROM worldnews EXCEPT (SELECT
headline,url,summary,updated FROM worldnews WHERE newssection='Archives'
UNION SELECT TOP 5 headline,url,summary,updated FROM worldnews WHERE
newssection='Archives' UNION SELECT TOP 5 headline,url,summary,updated FROM
worldnews WHERE newssection='Main') ORDER BY displayorder DESC
Also, if I execute the following statement, which you will notice involves
the same table and fields, on the same database:
SELECT TOP 5 headline,url,summary,updated FROM worldnews WHERE
newssection='Main' ORDER BY displayorder DESC
It executes as expected with no problem. What is the problem here? Did I
make a syntax error in the SQL statement that is giving me a problem? Is the
error because the query will return 0 records (The database does not have
many records yet since the site is not yet live)? Thanks.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/
Jun 3 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.