TNS-less Connection for Oracle Provider for OLE DB

This article deals with basics of Connection String for TNS-less Connection for Oracle Provider for OLE DB.
  • 4208

TNS-less Connection

The full form of TNS is TRANSPARENT NETWORK SUBSTRATE. It is basically a sql*net configuration file. It is used for defining address of databases so that a connection can be established. To establish a TNS-less connection use the following string.

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=OracleSID)(SERVER=DEDICATED)));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.