IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

Hi

I have this SQL statement:

Code:

---

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

---

I get this error:

Code:

---

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?

Does the SQL Command run in the SQL QUERY ANALYZER?

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

Try parameterizing the query.