Malathi

Malathi

  • NA
  • 20
  • 7.3k

Not able to connect to Oracle Database

Jun 24 2015 2:53 AM
Hi,
 
In Visual Studio 2012, when I try to use Data connection to connect to the Oracle Database [using Oracle Database [OracleClient],I am getting error. "ORA-12154: TNS:could not resolve the connect identifier specified".
 When I use Microsoft ODBC Data Source (ODBC), error is: "ERROR[IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". When I use .NET Framework Data Provider for OLE DB, error is: "ORA-6413: Connection not open."
I am able to connect using web.config connection string successfully.
 
How to connect to Oracle Database using "Server Explorer Data Connection".
 
Thanks in advance.

Answers (2)