Ask a Question

"Unexpected error from external database driver (1)" in TestComplete following MS update KB4041676

JennyH11
Frequent Contributor

"Unexpected error from external database driver (1)" in TestComplete following MS update KB4041676

Hi

 

We have recently installed the latest Windows updates on our test environments and have since noticed any tests that use Data-driven testing with Excel spreadsheets have stopped working. Any test that fails gives an "Unexpected error from external database driver (1)" message.

 

After scouring around online we have tried the following to resolve:

 

- Resaving a spreadsheet with 2007 format (.xlsx)

- Upgrading TestComplete to 12.4 version

- Downloading and installing the driver for Microsoft Access Database Engine 2010 (ACE)

 

The problem still occurred.

 

We then tried uninstalling the Windows update KB4041676 and the issue was resolved. Albeit, temporarily until Windows forces the install of the update again!

 

Does anyone know how to resolve this?

 

I'll be raising a Support case shortly to seek further help on this. Unfortunately, it seems something has changed which has caused this to break, either in the Windows update or somewhere else but it does seem significant that uninstalling KB4041676 seems to fix it...

 

Your help is appreciated.

 

Thanks,

Jenny

7 REPLIES 7
David91
Frequent Contributor

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

I have same problem!

tristaanogre
Community Hero

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

@David91, I would do what @JennyH11 and open a support case with SmartBear directly.  It sounds like there is something incompatible with some recent MS Office updates. You can create a support ticket at https://support.smartbear.com/message/?prod=TestComplete


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
JennyH11
Frequent Contributor

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

Unfortunately, the instruction I've been given is to disable Windows Updates to stop the issue from occurring.

 

I'm not sure this is a satisfactory response at present. Disabling Windows Updates is not something we want to do and would mean a change in process to how we currently work. I would usually expect the company releasing the software where the issue is displayed to act on the change made by Windows Updates... The software company I used to work would pro-actively test against the new Windows Updates when released and provide a patch if required to ensure their software functionality was unaffected and did not regress in any way for the customer.

 

I'm processing their response currently but that's my instinctive feeling on it so far....

 

 

I'm curious as to whether they've given you the same advice too @David91 

 

Thanks,

Jenny

tristaanogre
Community Hero

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

The thing is that not every Windows update is necessarily available ahead of time to do testing against... so, while it would be nice to be able to make sure that TC works with every Windows update, that's not always any easy thing to do.

 

Question:  For @David91, his particular problem is that he has the 32-bit version of MS Office installed and cannot install the 64-bit driver to use the 64-bit version of TC 12.40.  Are you in the same boat?  Can you try with the 64-bit version of the Microsoft Access driver?


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
tristaanogre
Community Hero

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

Additionally, try contacting SmartBear support directly... they may already have a patch or be working on one. 

 

https://support.smartbear.com/message/?prod=TestComplete


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
BillSimpson
Occasional Contributor

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda

This is a know Microsoft Problem with the Jet Engine, that Microsoft say they are working on.

 

https://support.microsoft.com/en-gb/help/4041676/windows-10-update-kb4041676

 

tristaanogre
Community Hero

Re: "Unexpected error from external database driver (1)" in TestComplete following MS upda


@BillSimpson wrote:

This is a know Microsoft Problem with the Jet Engine, that Microsoft say they are working on.

 

https://support.microsoft.com/en-gb/help/4041676/windows-10-update-kb4041676

 


That, and I believe that version 12.41 has TestComplete's fix for it as well.  Contact support to be sure.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
cancel
Showing results for 
Search instead for 
Did you mean: