Skip to Content

Unexpected error from external database driver

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.

Add comment
10|10000 characters needed characters exceeded

  • Former Member Former Member

    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.

  • 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

  • Former Member

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

  • Get RSS Feed

12 Answers

  • Best Answer
    Oct 12, 2017 at 08:12 PM

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

    We are investigating and informing Developers.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

  • avatar image
    Former Member
    Oct 18, 2017 at 01:05 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2017 at 03:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2017 at 02:37 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2017 at 04:58 PM

    Also discovered that KB4041681 is causing the problem as well.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2017 at 12:17 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2017 at 05:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 04:43 AM

    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!!!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 09:25 PM

    Then your only option is to not use Excel as a data source. Or log a bug with Microsoft to make it work again.

    Nothing CR did to break it so nothing we can do to fix it.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 10:16 PM

    Hi Ewelina

    We have discovered the best solution is to use OLEDB drivers instead.

    If you don't have OLEDB drivers, you will need to download them from Microsoft and get them installed. https://www.microsoft.com/en-au/download/details.aspx?id=54920 Remeber to use 32 bit drivers!!

    Then edit the report in Crystal and set the datasource location to the same file but use the OLE DB (ADO) drivers in the Set Datasource Location rather than Access/Excel (DAO).

    Make sure you use the full network path to the spreadsheet so the report can be run from the BO Server if required.

    If you have access to the BO Support site, you can find more details here: https://launchpad.support.sap.com/#/notes/2548907

    HTH!

    Add comment
    10|10000 characters needed characters exceeded