1812447 - Error: ORA-12154: TNS:could not resolve the connect identifier specified

SAP Knowledge Base Article - Public

1812447 - Error: ORA-12154: TNS:could not resolve the connect identifier specified

Symptom

  • Visual Studio application compiled as 32 bit
  • Reports are connecting to Oracle 11g
  • Application works as expected on 32 bit Operating System
  • On Windows Server 2008 Standard SP2 the followinr error is thrown:ORA-12154:

 ORA-12154: TNS:could not resolve the connect identifier specified

 

 

Environment

  • Crystal Reports for Visual Studio 2010
  • Visual Studio 2010
  • On Windows Server 2008 Standard SP2
  • Orcale 11g

Cause

Oracle client is installed incorrectly

Resolution

  1. On 64 bit Operating System, install Oracle driver 64 in home_oracle
  2. Install Oracle driver 32 in the same home_oracle
  3. Configure the ODBC driver to Oracle Home 1
  4. The ODBC DSN must be created using the \windows\syswow64\odbcad32.exe ( 32 bit ODBC Administrator )

Keywords

CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 Crystal Reports for .NET Framework 4.0 crforvs 13 2012 , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio