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.
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;
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