ODP.NET, Managed Driver supports SSL 3.0 and TLS 1.0, 1.1, and 1.2.
Close and Dispose OracleConnection objectĪlthough SSL was primarily developed by Netscape Communications Corporation, the Internet Engineering Task Force (IETF) took over development of it, and renamed it Transport Layer Security (TLS).Įssentially, TLS is an incremental improvement to SSL version 3.0. using connection string attributes to connect to Oracle DatabaseĬon.ConnectionString = "User Id=scott Password=tiger Data Source=oracle" Ĭonsole.WriteLine("Connected to Oracle" + con.ServerVersion) OracleConnection con = new OracleConnection()
The following example uses connection string attributes to connect to Oracle Database: // C# 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.
UNIVERSAL TYPE CLIENT 3.3.1 DOWNLOAD 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. The time to wait (in seconds) for a new connection or an idle connection from the connection pool before a connection time out error can occur. Minimum life time (in seconds) of the connection. Table 3-2 Supported Connection String Attributes Connection String AttributeĮnables database requests to automatically replay transactional or non-transactional operations in a non-disruptive and rapid manner in the event of a severed database session, which results in a recoverable error.
0 kommentar(er)
