[求助]C#中用OracleClient连接Oracle时，连接字符串怎么写?

Question

Provider=MSDAORA.1;Password=；User ID=;Data Source=...

Answer 1

Provider=MSDAORA.1  ??难到就在后面加个" .1" 就OK了？

Answer 2

使用OleDbConnection的:
ConnectionString=Provider=MSDAORA.1;Password=password;User ID=username;Data Source=kdc
OracleClient连接Oracle数据库:
"Password=User_Password;User ID=User_id;Data Source=kdc"

Answer 3

private string connectstring="Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=sid;Persist Security Info=True"; #region 连接数据库
public OleDbConnection ConnectDB() 
{
OleDbConnection conn=new OleDbConnection();
conn.ConnectionString=connectstring;
conn.Open();
return conn;
}
#endregion