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

• 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.

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

1. In Crystal Reports, create a new report.
2. In the Database Expert, under "Create New Connection", double click on "OLE DB(ADO)"
3. In the "OLE DB (ADO)" screen, select: "Microsoft OLE DB Provider for Oracle", and click "Next"
4. Enter the database information, user name and password.
   It then fails with a logon error.  

• Crystal Reports does not support connecting to Oracle using the Microsoft OLE DB Provider for Oracle. For reference, see the Crystal Reports supported platforms documents: 2859510
            
• The Microsoft OLE DB Provider for Oracle is a very old OLE DB Provider, and was not designed to connect to the latest versions of Oracle. It is planned to be removed from future versions of MS Windows. For reference, see the Microsoft documentation on the Microsoft OLE DB Provider for Oracle, where it states:  
            
  "Microsoft OLE DB Provider for Oracle: This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use Oracle's OLE DB provider."

• To connect to Oracle via an OLE DB connection in Crystal Reports:
• Install and configure the 32bit Oracle Client corresponding to the version of Oracle used; and
• Use the OLE DB provider installed by the Oracle client called: "Oracle Provider for OLE DB"

CR, OLEDB, ORA , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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