Oracle.ManagedDataAccess forcing me to hardcode server name in connection string

I just downloaded Oracle.ManagedDataAccess Version(4.122.1.0) via Nuget Package, and I'm developing using Visual Studio 2013, and the project framework is 4.0

Here is the problem I'm having. I'm able to connect to an Oracle database when I provide information like the host, port, and service name. However, I'm not able to connect when I just use the data source name. In other words....

Data Source=MySOURCE;User Id=MyId;Password=MyPass
-The above works with System.Data.OracleClient
-The above does not work with that Oracle.ManagedDataAccess dll.

The only way I can use the Oracle.ManagedDataAccess.dll is if I do something like this...

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver@something.com)(PORT=XXXX)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=NameXXX)));User Id=MyId;Password=MyPass


Any way to get around this with the Oracle.ManagedDataAccess dll?

This is the error I get....

Oracle.ManagedDataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect
identifier specified ---> OracleInternal.Network.NetworkException: ORA-12154: TNS:could not
resolve the connect identifier specified
silentthread2kSenior Software EngineerAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
If you use TNS naming, you need a tnsnames.ora file in the proper location.  I'm not sure of the default location using the Managed Driver because I never used those two in combination.

You can set the TNSADMIN environment variable to point to the location of the tnsnames.ora file.  I think the default location is in the app's home but don't quote me on that.

Anyway, that is the old school way these days. Everything is moving to the EZConnect method.

Try this:
Data Source=myserver@something.com:XXXX/NameXXX

There is more on it here:
http://www.oracle.com/technetwork/issue-archive/2014/14-mar/o24odp-2147205.html
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.