SAP Knowledge Base Article - Preview

2548907 - Error: 'Logon Failed. Unexpected error from external database driver' when refreshing a report based on MS Excel in Crystal Reports and in SAP BI LaunchPad

Symptom

  • DAO Connection to Excel fails.
  • ODBC connection to MS Excel fails.
  • Same report used to refresh successfully few days ago.
  • When refreshing a report in Crystal Reports connecting to a MS Excel spreadsheet, it fails with the error:
        
       Logon Failed. 
       Details: DAO Error Code: 0xccb
       Source: DAO.Workspace
       Description: Unexpected error from external database driver (1)
             
  • In SAP BI LaunchPad, when refreshing a report based of an Excel speadsheet, it prompts for the user name and password.
  • Reports scheduled in SAP BusinessObjects BI Sever, connecting to MS Excel are failing with the same error.
      
         
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
               
  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2
          
  • SAP Crystal Server 2011
  • SAP Crystal Server 2013
  • SAP Crystal Server 2016
          
  • MS Windows 7
  • MS Windows 8
  • MS Windows 10
  • MS Windows Server 2012

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

Database Access Engine, DAO, CR, Cannot logon, Excel, xls, xlsx , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.