1707285 - Error: Logon failed - Details: ADO Error Code 0x80004005 when connecting to Oracle 9 database

SAP Knowledge Base Article - Public

1707285 - Error: Logon failed - Details: ADO Error Code 0x80004005 when connecting to Oracle 9 database

Symptom

  • Creating a new report in the Crystal Reports Designer
  • Using the Microsoft OLE DB Provider for Oracle result in the error:

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]

 

 

Environment

  • Crystal Reports for Visual Studio 2010
  • Visual Studio 2010

Cause

  • Microsoft Oracle driver does not support Oracle 9
  • Support stopped as of Oracle 7
  • See ODBC Driver for Oracle for more information

Resolution

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03