Warning: Windows updates break interaction with .xls files from TestComplete
Please be aware that recent Windows updates break the JET driver which TestComplete uses to interact with Excel files saved in the old format (.xls). The issue may have different symptoms, but typically it’s an error message saying “Unexpected error from external database driver (1)”. Less popular error messages are "Reserved error (-5016)", "There is no message for this error (-5016)" or "General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process". It may appear when trying to edit the Data-Driven Loop operation in keyword tests, or during test playback - any attempt to interact with an .xls file from TestComplete may trigger this error.
Note that this is not a TestComplete issue: it’s Microsoft Windows updates breaking a Microsoft driver. However, TestComplete is using this driver to work with Excel files and therefore you may see unexpected errors in TestComplete. Microsoft is aware of this problem and they are planning to fix it:
>>>
Apart from this, Microsoft is working on a resolution and will provide an update in an upcoming release of the security patch. This is expected to be available in another 2-3 weeks or earlier.
<<<
In the meantime, an easy workaround (and the recommended solution from Microsoft) is to use the newer ACE driver instead of the JET driver which is obsolete. For that, you need to save the Excel file in the new format (.xlsx), which will make TestComplete use the newer ACE driver in the Data-Driven Loop keyword test operation or force TestComplete use the newer driver explicitly via setting the UseACEDriver parameter of the DDT.ExcelDriver method to true in scripts, like this:
DDT.ExcelDriver("c:\My File.xls", "Sheet1", true)
Please see the following KB article for more information on possible workarounds:
https://smartbear-cc.force.com/portal/KbArticleViewer?name=Unexpected-Driver-Error-2017&sp=TestComplete
According to the Microsoft article this issue has been fixed.
