skip to main content
Connection property descriptions : TNSServerName
  

Try DataDirect Drivers Now

TNSServerName

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