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

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