skip to main content
Connection property descriptions : TNSNamesFile
  

Try DataDirect Drivers Now

TNSNamesFile

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