Oracle ODP.NET数据库访问连接字符串

 

Connection String Attribute	默认值	描述
Connection Lifetime	0	Maximum life time (in seconds) of the connection 当数据库连接被返回到连接池中时，它的创建时间将与当前时间比较，如果超过了 Connection Lifetime 规定的时间，它将被释放掉。 为 0 时将被视为最大连接时间。
Connection Timeout	15	Maximum time (in seconds) to wait for a free connection from the pool
Data Source	empty string	Oracle Net Service Name that identifies the database to connect to
DBA Privilege	empty string	Administrative privileges: SYSDBA or SYSOPER
Decr Pool Size	1	Controls the number of connections that are closed when an excessive amount of established connections are unused
Enlist	true	Enables or disables serviced components to automatically enlist in distributed transactions 当此值为 true 时，池中现存的所有数据库连接将被加入到它的创建线程的 Transaction Context 中。如果不存在这个 Transaction Context 则无任何变化。
Incr Pool Size	5	Controls the number of connections that are established when all the connections in the pool are used
Max Pool Size	100	Maximum number of connections in a  pool
Min Pool Size	1	Minimum number of connections in a pool
Password	empty string	Password for the user specified by User Id
Persist Security Info	false	Enables or disables the retrieval of password in the connection string
Pooling	true	Enables or disables connection pooling
Proxy User Id	empty string	User name of the proxy user
Proxy Password	empty string	Password of the proxy user
User Id	empty string	Oracle user name

 

 

 

// C#

...

OracleConnection con = new OracleConnection();

con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle;Pooling=true;Enlist=true;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5; Decr Pool Size=2";

con.Open();

...

 

以下网站提供连接字符串大全：

www.ConnectionStrings.com