Easy Connect Naming Method in Oracle

This article tells about the usage of connection string of Easy Connect Naming Method in oracle.
  • 2171

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.