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.
  • 1912

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.