Geeks With Blogs


View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites

Anthony Trudeau

"Exception 80004005" has to be the worse error description I've seen.  This is not the error number, it's the description.  I received this error today when I was working on some legacy Visual Basic script in VisiWatch (an EAI application developed by SoftBrands).

There is some sporadic information out there on this error.  However, all of the guidance revolved around IIS code and suggested corruption, permissions, etc.  Of course this guidance led me on a wild goose chase.  After awhile I was able to isolate the problem to the specific SQL statement and not any type of connection method I was using (I was executing a Command and storing the result in a Recordset, and the connection was to a remote Access database that linked to another remote Access database -- so the setup is complex).

The problem?  One of the fields in the table queried is named "Language".  Apparently, ADO/OLEDB does not like that name and it fails with a totally useless error message.  The problem was solved by escaping the field name.

Posted on Wednesday, December 6, 2006 3:04 PM bugs | Back to top

Comments on this post: Exception 80004005

# re: Exception 80004005
Requesting Gravatar...
Happens when a field name is "exception" also.
Left by Van Carmen on Jan 16, 2007 11:22 AM

# re: Exception 80004005
Requesting Gravatar...
Thank you, I'm sure that'll come in handy.
Left by Anthony Trudeau on Jan 16, 2007 11:29 AM

# re: Exception 80004005
Requesting Gravatar...
Also happens with a table named "Usage". Argh! Thanks to your tip, I was able to figure out the cause and rename my table.
Left by Aaron on Jul 26, 2007 3:36 PM

# re: Exception 80004005
Requesting Gravatar...
By the way, if you use the GetSchema method of the OleDbConnection object with a collection name "ReservedWords" you will get a list of the words that cannot be used (USAGE is in the list).
Left by Anthony Trudeau on Jul 26, 2007 4:56 PM

# re: Exception 80004005
Requesting Gravatar...
I am getting the same problem but it is because of querying the Geometry from Oracle Spatial.

any comments for that please!!
Left by dauz on Jul 10, 2008 3:35 AM

Your comment:
 (will show your gravatar)

Copyright © Anthony Trudeau | Powered by: