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

Question

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

Kirtan Patel · Answer

Hi  Friend 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 dont use Size its Reserved keyword use anything else :) or Rewrite the Query Like Below (Elcolse Size in Single Quote 'Size' ) 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 Happy Coding :)

Xander Luus · Answer

Thank you so much @Kirten Patel

thong chu ba · Answer

My problem is the same this guy. Please help me! My query string : strSQL=Select [s].[StudentID] [s].[StudentName] [r].[MaAvg] (Case When [r].[MaAvg]>=5 then 'pass' else 'fail' end) as 'ResultCol' From Student s Result r where s.StudentID=r.StudentID; So someone please help me. Someone pls edit this query for me.

kawaljit singh · Answer

hey kirtan Thanks a lot it worked for me.........thnks friend.... :-)