1471508 - Logon error when connecting to Oracle database in a VS .NET application

SAP Knowledge Base Article - Public

1471508 - Logon error when connecting to Oracle database in a VS .NET application

Symptom

  • Connecting to an Oracle database
  • Using OLE DB connection type
  • VS .NET 2005, web application
  • Error:

Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for Oracle
Description: ORA-12154: TNS:could not resolve the connect identifier specified

Error in File C:\DOCUME~1\SYSENG~1\ASPNET\LOCALS~1\Temp\Report1 {155ED5E2-80F1-443F-960B-C2A2EFBD379E}.rpt:
Unable to connect: incorrect log on parameters

Cause

The ASP NET worker process did not have rights to read the tnsora file.

Resolution

Ensure the the ASP NET worker process has at least read permissions to the tnsora file

Keywords

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports XI R2