posts - 78, comments - 79, trackbacks - 84

My Links

News

View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites

Article Categories

Archives

Post Categories

Other Links

Exception 80004005

"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.

Print | posted on Wednesday, December 06, 2006 3:04 PM | Filed Under [ bugs ]

Feedback

Gravatar

# re: Exception 80004005

Happens when a field name is "exception" also.
1/16/2007 11:22 AM | Van Carmen
Gravatar

# re: Exception 80004005

Thank you, I'm sure that'll come in handy.
1/16/2007 11:29 AM | Anthony Trudeau
Gravatar

# re: Exception 80004005

Also happens with a table named "Usage". Argh! Thanks to your tip, I was able to figure out the cause and rename my table.
7/26/2007 3:36 PM | Aaron
Gravatar

# re: Exception 80004005

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).
7/26/2007 4:56 PM | Anthony Trudeau
Gravatar

# re: Exception 80004005

I am getting the same problem but it is because of querying the Geometry from Oracle Spatial.

any comments for that please!!
7/10/2008 3:35 AM | dauz

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 4 and 4 and type the answer here:

Powered by: