Forums - C# Corner

Forum guidelines

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 (3)

C# Corner Annual Conference 2017

SPONSORED BY

File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!