In Visual Studio 2012, when I try to use Server Explorer 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".
ODBC 64 BIT CONNECTION TO ORACLE SUCCESSFUL.
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.
All these errors are coming when I try to connect using "Visual Studio 2012 Server Explorer Data Connection".
How to connect to Oracle Database using "Visual Studio 2012 Server Explorer Data Connection".
Thanks in advance.