Connection strings

Easy Connect Naming

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 in that you do not have to create and manage a tnsnames.ora file. However, your application users must specify the host name and port number when they want to log in to your application.

In CalWin you can use this directly instead of the TNS alias name.

dbsrv:1521/orcl

You can also use the full description similar to what you find in the tnsnames.ora

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