Not able to connect to Oracle Database

Malathi

11y1.1k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Malathi11y ago
I have done all those things. Please read my question properly. I am getting errors after providing all the information like User name, password, server name etc. I am able to connect to the same x.udl [outside Visual Studio 2012] in Windows 8 Pro. Thanks and please do not mistake me. Malathi
Jaipal Reddy11y ago
goto Server explorer -> Right Click on Data Connections

-> Popup will open , click on Change buton and select oracle database click ok
-> provide your oracle database credentials server name, user name and password click ok