Question Re: Unexpected error from external database driver in Technology Q&A

Unexpected error from external database driver

Former Member — Thu, 12 Oct 2017 13:04:30 GMT

SAP Crystal Reports 16.

Standalone Windows 10 PC

Data saved as xls but in Office 365.

Since an update to Office yesterday, I get the error -

Logon failed - Details DAD Error Code 0xccb - Source DAO Workspace - Unexpected error from external database driver (1).

Access files work OK, but I need to use the spreadsheets.

Re: Unexpected error from external database driver

Former Member — Thu, 12 Oct 2017 14:01:23 GMT

I am seeing this too. I tracked it down to an update KB4041676; after uninstalling this update my CR worked fine. I hope someone at SAP can help or a new Microsoft Update fixes this issue.

Re: Unexpected error from external database driver

Former Member — Thu, 12 Oct 2017 14:54:00 GMT

Thank you - I will try to uninstall the update.

Re: Unexpected error from external database driver

Former Member — Thu, 12 Oct 2017 18:41:31 GMT

I am having identical problems however with different program versions as noted below. Also began after Microsoft updates on 10/10/17.

Crystal Reports 11

Office 2010

Windows 7 32 bit

I believe KB4041676 is Windows 10 related as it is not installed on my system. Hopefully a fix is on the way...

Re: Unexpected error from external database driver

vitaly_izmaylov — Thu, 12 Oct 2017 20:12:09 GMT

Several Users reported the same problem in the last couple of days.

We are investigating and informing Developers.

Re: Unexpected error from external database driver

Former Member — Fri, 13 Oct 2017 13:10:58 GMT

Yes, this KB4041676 is for Windows 10. I would try to narrow it down for your windows 7 machine on which update is causing the issue. I would talk to your system administrator though just in case.

Re: Unexpected error from external database driver

vitaly_izmaylov — Fri, 13 Oct 2017 14:52:37 GMT

The following solution approved by Developers:

Uninstall the following Microsoft KBs:

KB4041681 on Windows 7

KB4041676 on Windows 10

2548907 - Logon Failed. Unexpected error from external database driver in Crystal Reports connecting to Excel

Re: Unexpected error from external database driver

Former Member — Sat, 14 Oct 2017 16:56:59 GMT

I uninstalled the update KB4041676, and I could run my reports correctly.

But, the same update has automatically downloaded and prompted for a restart to finish installation. I have have uninstalled it again, I assume in it's wisdom Microsoft will continue to try to install. Assuming it is the same update as before, I will have the same problem.

I don not want to keep unistalling the update (which I assume contains stuff I need), so do any of you much cleverer users than me, know of a permament solution?

It's a standalone PC - on 24/7

Re: Unexpected error from external database driver

Former Member — Sun, 15 Oct 2017 11:49:02 GMT

But, that solution only lasts as long as it takes Microsoft to do the update again!

How do I , a non-technical person, prevent this.

Or do I resign myself to uninstalling every day?

Re: Unexpected error from external database driver

Former Member — Mon, 16 Oct 2017 10:19:05 GMT

Uninstalling KB4041681 on Windows 7 wasn't enough to fix this error for us. We also had to uninstall KB4041678 (Windows 7).

Re: Unexpected error from external database driver

Former Member — Mon, 16 Oct 2017 15:52:20 GMT

A slightly newer Windows security update, KB4041691, was the culprit. The update was downloaded and installed automatically on October 10, and that's when the trouble started. The KB4041691 was uninstalled and Crystal Reports returned to normal. I didn't turn the automatic update feature off, and of course the KB4041691 reinstalled itself, starting the problem all over again. Uninstalling the update (again) and turning the automatic update feature off cured the problem, and after turning the computer off and starting again today the problem continued to be cured.

Bottom line: if you are running a Windows 10 operating system, 64 bit, look either for the original culprit, KB4041676 or the one released on October 10, KB4041691, and uninstall it. Be sure to turn the automatic update feature off in the System Administration folder so you aren't gifted with another automatic update of the culprit file.

Re: Unexpected error from external database driver

Former Member — Tue, 17 Oct 2017 16:58:51 GMT

Also discovered that KB4041681 is causing the problem as well.

Re: Unexpected error from external database driver

Former Member — Wed, 18 Oct 2017 00:17:14 GMT

Same issue here on W7, uninstalling the October security updates, KB4041681 and 4041678 – solves the problem ( NOT a permanent solution obviously )

Re: Unexpected error from external database driver

Former Member — Wed, 18 Oct 2017 13:05:11 GMT

Same issue and NEITHER of the updates (KB4041681 / KB4041678) are installed - any alternative answers / data access suggestions for excel file? TIA

Re: Unexpected error from external database driver

Former Member — Wed, 18 Oct 2017 13:06:53 GMT

Same issue and NEITHER of the updates (KB4041681 / KB4041678) are installed - any alternative answers / data access suggestions for excel file? TIA

Re: Unexpected error from external database driver

vitaly_izmaylov — Wed, 18 Oct 2017 14:37:17 GMT

See alternative solution on another thread:

https://answers.sap.com/questions/332500/crystal-reports-error-after-windows-update.html

Re: Unexpected error from external database driver

nambi2 — Fri, 20 Oct 2017 17:55:45 GMT

This update has caused me a lot of grief! almost a week to narrow it down, KB4041681 was causing this issue for me, for now I have halted all automatic update.

This would affect office 2007 excel, I think upgraded the excel to 2013 and the same issue.

Server 2008

Re: Unexpected error from external database driver

Former Member — Fri, 03 Nov 2017 14:44:52 GMT

Does this happen on the newer versions of Crystal? I am thinking of just biting the bullet and upgrading...

Re: Unexpected error from external database driver

Former Member — Mon, 06 Nov 2017 04:43:16 GMT

What is the solution for people who can't uninstall the updates?

I read something here about using OLEDB drivers but this is not clear and I can't find a solution that allows me to run a Crystal report from an Excel (xls) spreadsheet on a different server ???? Please help!!!

Re: Unexpected error from external database driver

Former Member — Tue, 07 Nov 2017 21:23:21 GMT

Hello,

I am experiencing the same issue. I DO NOT have the option to uninstall any patch on my system. Please advise if there is any other way I can setup crystal and excel to pull my report.

Greatly appreciate any input.