Question

企业版Sql server 2008 web.config中数据库连接字符串怎么写

Answer 1

<connectionStrings>
<!--<add name ="AccountID" connectionString ="001"/>
<add name="ServerIP" connectionString="192.168.1.77"/>
<add name="DataBase" connectionString="UFDATA_001_2011"/>
<add name="UserName" connectionString="sa"/>
<add name="Password" connectionString="Lhpc@123"/>-->
<add name="AccountID" connectionString="006"/>
<add name="ServerIP" connectionString="192.168.1.77"/>
<add name="DataBase" connectionString="UFDATA_006_2011"/>
<add name="UserName" connectionString="sa"/>
<add name="Password" connectionString="Lhpc@123"/>
<add name="PROCConnectionString" connectionString="Data Source=192.168.1.77;Initial Catalog=UFDATA_006_2011;User Id=sa;Password=Lhpc@123;" providerName="System.Data.SqlClient"/>
</connectionStrings>

按照上面的样式改吧

Answer 2

链接字符串不分你是什么板版本的VS
<add key="ConnectionString" value="Data Source=192.168.1.2;Initial Catalog=mydata;User ID=sa;Password=sa"/>