Easy Connect Naming Method in Oracle
This article tells about the usage of connection string of Easy Connect Naming Method in oracle.
Connection To An Instance
For connecting with an instance we use an Easy Connect Naming Method. IT connects a program and an instance without any need of configuration. The string given below is does not require a need of specifying service or a port.
| Data Source=username/password@myserver//instancename; |
Connection To A dedicated server instance
For connecting to a dedicated server instance we use an Easy Connect Naming Method. IT connects a program and an instance without any need of configuration. The string given below is does not require a need of specifying service or a port.
| Data Source=username/password@myserver/myservice:shared/instancename; |
NOTE: Pooled and Dedicated are other options that can be used. By default the option is Dedicated.
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