0

I upgrade ALM and UFT to the latest version. There is no GUI change, but when i run the old script it shows this error:

The Microsoft Jet database engine could not find the object 'TestData$'. Make sure the object exists and that you spell its name and the path name correctly.

Function file: [ALM\Resources] Resources\CRAFT Framework\Reusable Libraries\Framework_Utilities\ExcelDataAccess.vbs Line (76): "objTestData.Open strQuery, m_objConn".

Community
  • 1
  • 1
Sam
  • 1
  • 2
  • 1
    Sounds like you are trying to query a worksheet in an excel file that doesn't exist... Check your excel file contains a worksheet called `TestData` – Dave Jun 20 '17 at 16:28
  • Check the path in the connection string that is passed to m_objConn object. That path may not exist or that sheet TestData$ may have been removed or renamed. – Mithilesh Indurkar Jun 22 '17 at 13:48
  • Thanks! @ Dave and @ Mithilesh – Sam Jun 26 '17 at 13:19
  • @ Dave i am using hybrid frame work ,and the script is old. i am trying to run this old script in new environment. There is no change in functionality, but the developers used upgraded version of .NET. I am not sure where to find TestDta and not also able to change new test server in UFT. – Sam Jun 26 '17 at 14:40

1 Answers1

0

You can check the parameter values in ALM to know the location of excel sheet.

Abhilash Khare
  • 21
  • 2