E_FAIL 0x80004005

  • Thread starter Thread starter Oscar Thornell
  • Start date Start date
O

Oscar Thornell

Hi,

I am getting the COM error 0x80004005 (Microsoft OLE DB Provider for ODBC
Drivers) when I try to do a simple select query via OleDb in ADO.NET on an
Access 2003 db. The application is an ASP.NET web app running on a Win XP
prof with VS.Studio 2003 (.Net 1.1)..

This code executes fine:

String sql = "SELECT * FROM Test";
OleDbCommand cmd = new OleDbCommand(sql, conn);
reader = cmd.ExecuteReader();


Whereas this generates the error (from ADO.NET..):

String sql = "SELECT * FROM Test WHERE Language='EN'";

it does however run fine from inside Access in a "normal" select query...

Any ideas??

Regards
/Oscar
 
It's a long shot, but see whether putting square brackets around Language
makes a difference:

String sql = "SELECT * FROM Test WHERE [Language]='EN'";

Perhaps ADO.Net treats Language as a reserved word.
 
Thanks Doug!!
Your longshot did it...
:-)
/Oscar


Douglas J. Steele said:
It's a long shot, but see whether putting square brackets around Language
makes a difference:

String sql = "SELECT * FROM Test WHERE [Language]='EN'";

Perhaps ADO.Net treats Language as a reserved word.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Oscar Thornell said:
Hi,

I am getting the COM error 0x80004005 (Microsoft OLE DB Provider for ODBC
Drivers) when I try to do a simple select query via OleDb in ADO.NET on an
Access 2003 db. The application is an ASP.NET web app running on a Win XP
prof with VS.Studio 2003 (.Net 1.1)..

This code executes fine:

String sql = "SELECT * FROM Test";
OleDbCommand cmd = new OleDbCommand(sql, conn);
reader = cmd.ExecuteReader();


Whereas this generates the error (from ADO.NET..):

String sql = "SELECT * FROM Test WHERE Language='EN'";

it does however run fine from inside Access in a "normal" select query...

Any ideas??

Regards
/Oscar
Click to expand...
Click to expand...
 
Douglas said:
It's a long shot, but see whether putting square brackets around
Language
makes a difference:
Click to expand...


YOUR MESSAGE SAVED ME!!!!

"How to" join tables in asp.net with OleDBData and DataSet

cheers kim
 
Back
Top