Error when loading .xls file into Data tab in API Test

  • Questions
  • Error when loading .xls file into Data tab in API Test
Question ID: 107917
1
0

This has been working up until now. Not sure what the problem is….
When we’re trying to load an .xls file into the data tab of an API test, we’re getting the following error:

Exception of type: System.Data.OleDb.OleDbException. Source: Microsoft JET Database Engine. Occured in Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection) method
Exception message is: Unexpected error from external database driver (1).
This was working fine with no problem last week! Help?

Marked as spam
Posted by (Questions: 344, Answers: 24)
Asked on October 23, 2017 8:50 pm
5 views
Answers (1)
1
Private answer

We've found that [Microsoft Update KB4041681][1] is causing problems. In it, Microsoft notes:

Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, ''Unexpected error from external database driver (1). (Microsoft JET Database Engine)''.

If you can roll back to a restore point prior to this update or uninstall the update, it should work again.

Microsoft states in the article that they are working on a fix for these issues.

[1]: https://support.microsoft.com/en-us/help/4041681/windows-7-update-kb4041681

Marked as spam
Posted by (Questions: 16, Answers: 754)
Answered on October 23, 2017 8:51 pm
We were able to roll back and now things are working again.
( at October 23, 2017 8:54 pm)
We're finding that this KB and [kb4041678][1] are causing similar issues and other issues with both UFT and ALM. We are seeing some instances where both patches being uninstalled will resolve some of the issues. [1]: https://support.microsoft.com/en-us/help/4041678/windows-7-update-kb4041678
( at October 26, 2017 4:03 pm)