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 | Connection properties to use for authentication. Accepted entries are Server, OracleTNS, LDAP. |
Server | The host name or IP of the server hosting the Oracle database. |
Port | The port used to connect to the server hosting the Oracle database. |
ServiceName | The service name of the Oracle database. |
User | The Oracle OCI user account used to authenticate. |
Password | The password used to authenticate the user. |
DataSource | Oracle Net Services Name, Connect Descriptor (known also as TNS Connect String), or an easy connect naming that identifies the database to which to connect. |
LDAPUri | LDAP uri to connect the LDAP server. |
LDAPUser | The User account for LDAP server. |
LDAPPassword | The password for the LDAP user. |
LDAPVersion | The LDAP version used to connect to and communicate with the server. |
Property | Description |
LogModules | Core modules to be included in the log file. |
Property | Description |
Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
IncludeSynonyms | Query meta data for synonyms as they are being the reqular tables. |
ShowMetadataDescriptions | Controls whether table and column descriptions are returned via the platform metadata APIs and sys_tables / sys_views / sys_tablecolumns. |
UseDBAMetadataViews | Query meta data from DBA_.. system views instead of ALL_.. system views. |
Property | Description |
AllowPreparedStatement | Prepare a query statement before its execution. |
MaxLobSize | The volume in numbers of bytes or UTF-8 chars which is allowed to query by non-parameterized SELECT query. |
MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
Other | These hidden properties are used only in specific use cases. |
Readonly | You can use this property to enforce read-only access to Oracle OCI from the provider. |
ReconnectTimeout | The sleep time, in seconds, before retrying to reconnect to the server on a maximum idle time exceeded error. |
ReconnectTries | The number of retry to connect server when a maximum idle time exceeded error is reported by server. |