I just downloaded Oracle.ManagedDataAccess Version(18.104.22.168) 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)(HOSTfirstname.lastname@example.org)(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