Purpose

The path and filename to the tnsnames.ora file from which connection information is retrieved. The tnsnames.ora file contains connection information that is mapped to Oracle net service names. Using a tnsnames.ora file to centralize connection information simplifies maintenance when changes occur.

Valid Values

string

where:

string
is a valid path to and file name of a tnsnames.ora file.

Behavior

If you specify this property, you also must specify the TNSServerName property.

Notes

  • If this property is specified, do not specify the following properties to prevent connection information conflicts:

    AlternateServers

    FailoverMode

    LoadBalancing

    PortNumber

    ServerName

    ServerType

    ServiceName

    SID

    If any of these properties are specified in addition to this property, the driver throws an exception.

Default

None

Data Type

String

See also

Using tnsnames.ora Files