Using Oracle Data Provider for .NET
page 4 of 4
by Steven Swafford
Average Rating: 
Views (Total / Last 10 Days): 63111/ 116

ODP.Net Connection String Attributes

Connection String Attributes

Attribute - Connection Lifetime
Default value - 0
Description - Maximum life time (in seconds) of the connection

Attribute - Connection Timeout
Default value - 15
Description - Maximum time (in seconds) to wait for a free connection from the pool

Attribute - Data Source
Default value - empty string
Description - Oracle Net Service Name that identifies the database to connect to

Attribute - DBA Privilege
Default value - empty string
Description - Administrative privileges: SYSDBA or SYSOPER

Attribute -Decr Pool Size
Default value - 1
Description - Controls the number of connections that are closed when an excessive amount of established connections are unused

Attribute - Enlist
Default value - true
Description - Enables or disables serviced components to automatically enlist in distributed transactions

Attribute - Incr Pool Size
Default value - 5
Description - Controls the number of connections that are established when all the connections in the pool are used

Attribute - Max Pool Size
Default value - 100
Description - Maximum number of connections in a pool

Attribute - Min Pool Size
Default value - 1
Description - Minimum number of connections in a pool

Attribute - Password
Default value - empty string
Description - Password for the user specified by User Id

Attribute- Persist Security Info
Default value - false
Description - Enables or disables the retrieval of password in the connection string

Attribute - Pooling
Default value - true
Description - Enables or disables connection pooling

Attribute - Proxy User Id
Default value - empty string
Description - User name of the proxy user

Attribute - Proxy Password
Default value - empty string
Description - Password of the proxy user
User Id   empty string Oracle user name

Now we finally get to a Pooling Example.

OracleConnection con = new OracleConnection();
con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle;" +
"Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" +
"Incr Pool Size=5; Decr Pool Size=2";

View Entire Article

User Comments

Title: ODP for .NET   
Name: Adam Woods
Date: 2005-01-28 6:44:06 AM
Very good example and well narrated, been looking for a clear C# focused example for some time now, my search is over. Thanks

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-11-29 1:33:31 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search