c#,oracle的连接字符串，sys用户的解决办法。

 }

所以说，用.net新提供的managed provider来访问oracle数据(system.data.oracleclient),
是无法以sys用户登录的。
这只有使用oracle odp.net（可以去oracle官方网站下载）

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