Question

asp.net连接oracle数据库

我的链接字符串是写在配置文件里面的,如下：<add key="ConnectionString" value="Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;User ID=xxx;Password=xxx"></add>
然后再按钮里面代码如下：
string conStr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
OracleConnection conn = new OracleConnection(conStr);
conn.Open();
运行的时候报错，说不支持provider关键字，请问怎么能改啊！

Answer 1

将<add key="ConnectionString" value="Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;User ID=xxx;Password=xxx"></add>
换成：
<add key="ConnectionString" value="Data Source=orcl;User ID=xxx;Password=xxx"/>

Answer 2

New version:

"Driver=;Server=OracleServer.world;Uid=Username;Pwd=asdasd;"

Old version:

"Driver=;ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"

Answer 3

oracle是这样的：
value="Data Source=orcl;User ID=xxx;Password=xxx;"