Purpose

The Oracle net service name that is used to reference the connection information in a tnsnames.ora file. The value of this property must be a valid net service name entry in the tnsnames.ora file specified by the TNSNamesFile property.

Valid values

string

where:

string
is a valid Oracle net service name.

Behavior

If this property is specified, you also must specify the TNSNamesFile 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

setTNSServerName

Default

None

Data type

String

See also

Using tnsnames.ora Files