skip to main content
Using the driver : Using connection properties : Required properties
  

Try DataDirect Drivers Now

Required properties

The following table summarizes connection properties required to connect to a database.
Table 4. Required properties
Property
Characteristic
Specifies the distinguished name for the LDAP entry that contains your connection information. Using an LDAP entry provides simplified maintenance by allowing you to centrally store and access connection information.
Note: If this property is specified, do not specify value for the following properties: AlternateServers, FailoverMode, LoadBalancing, SDUSize, ServerType, ServiceName, SID, TNSNamesFile, and TNSServerName.
Specifies the TCP port of the primary database server that is listening for connections to the database.
The default is 1521.
Specifies the name or IP address of the server to which you want to connect.
Database service name that specifies the database used for the connection.
Note: This property is mutually exclusive with the LDAPDistinguishedName, SID, TNSNamesFile, and TNSServerName properties.
SID
Oracle System Identifier that refers to the instance of the Oracle database running on the server.
Note: This property is mutually exclusive with the LDAPDistinguishedName, ServiceName, TNSNamesFile, and TNSServerName properties.
The default is ORCL.
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.
Note: This property is mutually exclusive with the ServerName, PortNumber, LDAPDistinguishedName, SID, and ServiceName properties.
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.
Note: This property is mutually exclusive with the ServerName, PortNumber, LDAPDistinguishedName, SID, and ServiceName properties.