OracleConnection con = new OracleConnection() The following example uses connection string attributes to connect to Oracle Database: Validation of connections coming from the pool. Statement cache enabled and cache size, that is, the maximum number of statements that can be cached. Statement cache purged when the connection goes back to the pool. Indicates whether or not a transaction is local or distributed throughout its lifetime.Įnables or disables self-tuning for a connection.
Oracle odbc driver connection string password#
Retrieval of the password in the connection string. Password for the user specified by User Id. Number of new connections to be created when all connections in the pool are in use. Works with Oracle Global Data Services, including Oracle RAC, Active Data Guard, and GoldenGate. Works with Oracle Global Data Services, including Oracle RAC, Data Guard, GoldenGate, and some single instance deployments.Įnables ODP.NET connection pool to balance work requests across Oracle database instances based on the load balancing advisory and service goal. Number of connections that are closed when an excessive amount of established connections are unused.Ĭontrols the enlistment behavior and capabilities of a connection in context of COM+ transactions or System.Transactions.Įnables ODP.NET connection pool to proactively remove connections from the pool when an Oracle database service, service member, instance, or node goes down. Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect.Īdministrative privileges: SYSDBA or SYSOPER. Returns an implicit database connection if set to true. Minimum time (in seconds) to wait for a free connection from the pool. Minimum life time (in seconds) of the connection. Table 3-2 Supported Connection String Attributes Connection String Attribute