关于在web.config配置连接字符串的问题，谢谢

Question

你好，我的虚拟主机提供商要求数据库连接字符串为Set conn = Server.CreateObject("ADODB.Connection")
connstr = "PROVIDER=SQLOLEDB;Server=(local);DATABASE=sq_cnipiptest;UID=sq_cnipiptest;PWD=123456;"
conn.Open connstr 
可是我想把连接字符串写在web.config里，请问如何写？

我是这么写的：<add key="aaa" value="Data Source=(local);Initial Catalog=xxxxxxxx;User ID=xxxxxxxxx;Password=xxxxxxxxxxxxxx"/>

<add name="aaaaa" connectionString="Data Source=(local);Initial Catalog=xxxxxxxx;Integrated Security=True" providerName="System.Data.SqlClient"/>
可是不行……谢谢！！

Answer 1

Standard Security:
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Trusted connection:
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; 
Connecting to an SQL Server instance:
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI;
Connect via an IP address:
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Answer 2

这样写就可以了：
<connectionStrings>
<add name="aaa" connectionString="Data Source=servername;initial catalog=dbname;uid=sa;pwd=12345678;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Answer 3

<connectionStrings>
    <add name="connStr" connectionString="Data Source=servername;initial catalog=sq_cnipiptest;uid=sq_cnipiptest;pwd=123456;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Answer 4

C#程序中可以这样调用：(VB类似)
protected string m_strConnectionString = ConfigurationManager.ConnectionStrings["aaa"].ConnectionString;