Help me! 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 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; Someone pls help me. Someone pls edit this query for me. Thanks!

Sam Hobbs · Answer

You can create a Data Source in the Data Sources window then use the Query Designer to ensure the query is valid. When I do that I get the following query that works: SELECT s.StudentID s.StudentName r.MaAvg (CASE WHEN [r].[MaAvg] >= 5 THEN 'pass' ELSE 'fail' END) AS 'ResultCol' FROM Student AS s INNER JOIN Result AS r ON s.StudentID = r.StudentID