Connection String Options
The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.
For more information on establishing a connection, see Basic Tab.
| Property | Description |
| ConnectionType | Specifies the method used to connect to Oracle OCI data. |
| Server | The host name or IP of the server hosting the Oracle database you want to connect to. |
| Port | The port on which the Oracle OCI database service specified in the ServiceName connection property is hosted. |
| ServiceName | The service name of the Oracle database you want to connect to. |
| SID | The unique system identifier (SID) of the Oracle OCI database instance you want to connect to. |
| User | Specifies the authenticating user's user ID. |
| Password | Specifies the authenticating user's password. |
| DataSource | Specifies the Oracle database to connect to, using the Net Services Name, Connect Descriptor (TNS Connect String), or connection name. |
| LDAPUri | LDAP URI associated with the LDAP server you want to connect to. |
| LDAPUser | The name of the user account on the specified LDAP server that you want to use to connect to Oracle OCI data. |
| LDAPPassword | The password associated with the LDAP user specified in the LDAPUser connection property. |
| LDAPVersion | The LDAP version used to connect to and communicate with the Oracle OCI server. |
| Wallet | The directory where the client's Oracle Wallet is located. |
| Property | Description |
| LogModules | Specifies the core modules to include in the log file. Use a semicolon-separated list of module names. By default, all modules are logged. |
| Property | Description |
| Location | Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path. |
| IncludeSynonyms | Specifies whether metadata is queried for synonyms as though they are the original tables. |
| ShowMetadataDescriptions | Controls whether table and column descriptions are returned via the platform metadata APIs and sys_tables / sys_views / sys_tablecolumns. |
| UseDBAMetadataViews | Specifies whether to obtain metadata from system views prefixed with 'ALL' or those prefixed with 'DBA'. |
| Property | Description |
| AllowPreparedStatement | Prepare a query statement before its execution. |
| MaxLobSize | The maximum number of bytes to display in records for fields of LOB data types. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| NativeFolder | The path to the directory containing the native assemblies (.dll) the provider works with. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| Readonly | Toggles read-only access to Oracle OCI from the provider. |
| ReconnectTimeout | The sleep time, in seconds, before attempting reconnect to the server after exceeding the maximum idle time for a connection attempt. |
| ReconnectTries | The number of reconnection attempts that are made after exceeding the maximum idle time for an initial connection attempt. |