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

    • LDAPDistinguishedName

    • LoadBalancing

    • PortNumber

    • SDUSize

    • ServerName

    • ServerType

    • ServiceName

    • SID

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

Data source method

setTNSNamesFile

Default

None

Data type

String

See also

Using tnsnames.ora Files