Monday, September 3, 2012

ORA-12154:TNS: could not resolve the connect identifier specified, visual studio, ODP.NET

Trying to connect from Visual Studio 2010 to Oracle Express 11g on my local machine using ODP.NET.

However get the following error message:





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

1. Able to connect from Oracle XE database from Oracle SQL Developer, TOAD, Erwin etc.

What Worked
In the data source name box, instead of XE use:

localhost:1521/XE

 It worked flawlessly.

No comments:

Post a Comment