SAP Knowledge Base Article - Preview

1707285 - Error: 'Logon failed - Details: ADO Error Code 0x80004005', when using a Microsoft OLEDB connection to Oracle from Crystal Reports

Symptom

  • Logon failed error.
  • Unable to create a new report to Oracle in Crystal Reports.
  • When refreshing a report based on Oracle that uses the Microsoft OLE DB Provider for Oracle, it fails.
  • When trying to connect to Oracle in Crystal Reports, using Microsoft OLE DB Provider for Oracle, it fails with an error like:

    Logon failed.
    Details: ADO Error Code 0x80004005
    Source: Microsoft OLE DB Provider for Oracle
    Description: ORA-12203 : TNS: unable to connect to destination
    Native Error: 12203 [database vendor code: 12203]
         
     or

    Logon failed.
    Details: ADO Erro Code: 0x800004005
    Source: Microsoft OLE DB Provider for Oracle
    Description: Error while trying to retrieve text for error ORA-01019
    Native Error: 1019 [Database Vendor Code: 1019]
      
     or

    Logon failed.
    Details: ADO Erro Code: 0x800004005
    Source: Microsoft OLE DB Provider for Oracle
    Description: Oracle client and networking components were not found.
    These components are supplied by Oracle Corporation and are part of
    the Oracle 7.3.3 or later client software installation.
      
    Provider is unable to function until these components are installed.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
         
  • SAP Crystal Reports for Visual Studio
         
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Product

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

Keywords

CR, OLEDB, ORA , 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 ONE Support launchpad (Login required).

Search for additional results

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