Skip to Main Content

Configuration to refer TNSNAMES.ora File

RameshSagarJan 28 2022

Hi Team,
I have an ASP.NET application that refers resource.config file to connect to Database. The resource.config file contains Database connection string as shown below-
<ConnectionString>Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.11.11.13)(PORT=9119)))(CONNECT_DATA=(SERVICE_NAME=DEVDB)));</ConnectionString>
But I want this connection string to be in tnsnames.ora file and in my resource.config file I just want to put a reference to that tnsnames.ora file, so that my ASP.NET application when refer to resource.config file for Database connection string, it just get the connection string from tnsnames.ora.
Oracle details as below:-
Oracle 19c
Any guidance is highly appreciated.

Thanks in advance!
Ramesh

Comments
Post Details
Added on Jan 28 2022
0 comments
2 views