Specifying a Connection by Using the Easy Connect Naming Method

You can specify a connection address to an Oracle Database directly from a client application, without having to configure a tnsnames setting for the Instant Client. This method is convenient as you do not have to create and manage a tnsnames.ora file. However, the application users must specify the host name and port number when they want to log in to the application.

For example, if you run SQL*Plus on the client computer and want to connect to the sales_us database, which is located on a server whose host name is shobeen and port number is 1521, then you can log in as follows:

sqlplus system/admin@shobeen:1521/sales_us

Similarly, in the application code, you can use Oracle Call Interface net naming methods to create the Instant Client-to-Oracle Database connection. For example, the following formats in the OCIServerAttach() call specify the connection information:

• Specify a SQL connect URL string using one of the following format:

  [ ( username, [ "/", password ] | "/" ), [ "@", db_address ] ], [ admin_role ], [ initial_edition ]

  or

  username/password@inst1

• Alternatively, you can specify the SQL connect information as an Oracle Net keyword-value pair. For example:

  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=shobeen) (PORT=1521))
  (CONNECT_DATA=(SERVICE_NAME=sales_us)))"
  

  See Also:

  Oracle Call Interface Programmer's Guide