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)

techbash 2016

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!