System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Aug 9 2009 4:56 AM

hi every body
here's my problem, m gettin this error(System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005)) while using this query

SELECT sc.schoolname, t.itemname, i.itemsize as Size, Count(*) as iTemCount FROM schoolitemmap s, iTemTypes t, iTemTable i, School sc WHERE s.SchoolId = 1 and s.schoolid=sc.schoolid and s.itemid=i.itemid and t.itemtypeid=i.itemtypeid and s.g_or_b = 0 group by sc.schoolname, t.itemname, i.itemsize


statement may be a reserved word by using [] these somewhere (:-P) . So someone please help me. Someone pls edit this query for me.

Thanks

Answers (4)