on 10-12-2017 2:04 PM
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.
Several Users reported the same problem in the last couple of days.
We are investigating and informing Developers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The following solution approved by Developers:
KB4041681 on Windows 7
KB4041676 on Windows 10
Same issue and NEITHER of the updates (KB4041681 / KB4041678) are installed - any alternative answers / data access suggestions for excel file? TIA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Windows latest patch is out yesterday 17th Nov 2017. After installing it the issue resolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See alternative solution on another thread:
https://answers.sap.com/questions/332500/crystal-reports-error-after-windows-update.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Same issue here on W7, uninstalling the October security updates, KB4041681 and 4041678 – solves the problem ( NOT a permanent solution obviously )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also discovered that KB4041681 is causing the problem as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.