Eliminat Tnsnames.ora in .NET Framework for Oracle
This article deals with concepts of connection string to be used in Tnsnames.ora in .NET Framework Data Provider for Oracle.
Eliminating the Tnsnames.ora
TNSNAMES.ORA is basically a configuration file (SQL*Net) residing in ORACLE HOME\NETWORK\ADMIN directory is used for storing database addresses for establishing connections to them. The connection string given below does not require a system to have a data source name(DNS) for the connection. Hence to omit the tnsnames.ora file use the following command.
| Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=Username;Password=user_Password; |
Further Readings
You may also want to read these related articles.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here