Forums - C# Corner

Forum guidelines
Nel

Nel

  • 764
  • 699
  • 909.4k

IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

Nov 16 2011 7:40 AM
Hi could anybody help me please what is the problem with  my code?

I get this error IErrorInfo.GetDescription failed with E_FAIL(0x80004005)
on this row

oleDBDataAdapter1.SelectCommand=command;

I suppose that the error is in select statement. Here is the code

SELECT NOVI.GBR as gbrnov, NOVI.AB as abnov, NALOG1.DATA as datanov,Min(NALOG1.POCKM) AS MinOfPOCKM, Max(NALOG1.KRAJKM) AS MaxOfKRAJKM,(Max(NALOG1.KRAJKM)-Min(NALOG1.POCKM)) AS RAZLIKA,  (MAGACIN.KOL)/100 AS Potr100km, MAGACIN.SIFRA, (case when [MAGACIN.SIFRA]='0991000' then [MAGACIN.KOL] else null end as 'Gorivo', case when [MAGACIN.SIFRA]='0993050' then [MAGACIN.KOL] else null end as 'Maslo'), NOVI.DATAP AS poslprov, NOVI.DATAS AS poslservis FROM (NALOG1 INNER JOIN MAGACIN ON NALOG1.GBRV=MAGACIN.GBR) INNER JOIN NOVI ON NALOG1.GBRV=NOVI.GBR where ( ( ( (NOVI.GBR)>=? And (NOVI.GBR)<=? ) ) AND (   (NOVI.AB)=?   or  (NOVI.AB)=?) AND ( ( (NALOG1.DATA)>=?) and ((NALOG1.DATA)<=?) ) ) GROUP BY NOVI.GBR, NOVI.AB, NALOG1.DATA,  NOVI.DATAP, NOVI.DATAS

Before I insert the code for MAGACIN.SIFRA and MAGACIN.KOL everything worked fine.

Thanks

Answers (3)

VSLive! Anaheim

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!