IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

[modernthinker]

Hi

I have this SQL statement:

string Messages_SQL = "SELECT COUNT(Questions) FROM Progress WHERE QuestionBy = '" + Session["User"]+ "' AND Read = 'No'";

I get this error:

IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

If i comment out the "AND Read = 'No'" part then it works but obviously i don't get the results i need.

Anyone see what i am doing wrong?

[Lord_Rat]

Does the SQL Command run in the SQL QUERY ANALYZER?

I suspect the Session["User"] is munging your query.

Try parameterizing the query.