TNSServerName
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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
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