Issue with "Excel" operations component in HPOO 7.6
We are using HPOO 7.6 version with windows 2003 server OS SP2 64 bit edition and MSSQL 2005 server DB.
We have an issue with the "Excel" operations component wherein when we try to query for a value from a column in the .xls sheet its returning the below error message.
"returnResult=Provider cannot be found. It may not be properly installed.;Result=Provider cannot be found. It may not be properly installed.;sessionId=bea036b4-5fc2-4704-9bca-2a9068121e9a;exception=System.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at dotNETWebActions_Excel.ExcelDB..ctor(String path, Boolean header)
at dotNETWebActions_Excel.Excel.Execute(ActionRequest req, ISession s, IActionRegistry reg)".
Kindly request you assist us on this issue,would appreciate prompt response.