SAP Knowledge Base Article - Public

1333131 - Error:"Logon failed. Details: HY000;[Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error"

Symptom

  • Error: "Logon failed. Details: HY000;[Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error [Database Vendor Code: 12560]" while creating new Crystal report with ODBC connection for Oracle.

Cause

  • TNS Service Name field is blank in Oracle ODBC Driver Configuration window for Oracle Data Source Name (DSN).

Resolution

  1. Go to Control Panel-> Administrator Tools and open "Data Sources (ODBC)" on the client machine.
  2. Select the DSN for Oracle and click on Configure button.
  3. Provide appropriate TNS Service Name in the "TNS Service Name" field in Oracle ODBC Driver Configuration window and click on OK.

Keywords

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

Product

SAP Crystal Reports XI R2