web.config中的连接字符串无法连接 [英] Connection String in web.config fails to connect
问题描述
我决定将我的项目从工作转移到家里,我在连接到数据库时遇到一些麻烦。这一个适用于工作:
web.config:
; connectionStrings>
< add name =ApplicationServicesconnectionString =Data Source = XXXXXX\SQLSERVER2008; Persist Security Info = true; Initial Catalog = esResearch; User ID = XXXXXX; Password = XXXXXX
providerName = System.Data.SqlClient/>
< add name =esResearchConnectionStringconnectionString =Data Source = XXXXXX\SQLSERVER2008;初始目录= esResearch; Persist安全信息= True;用户ID = XXXXXX;密码= XXXXXX
providerName = System.Data.SqlClient/>
< / connectionStrings>
app.config:
< connectionStrings>
< add name =esResearchModels.Properties.Settings.esResearchConnectionString
connectionString =Data Source = XXXXXX\SQLSERVER2008;初始目录= esResearch; Persist安全信息= True;用户ID = XXXXXX
providerName =System.Data.SqlClient/>
< add name =esResearchModels.Properties.Settings.esResearchConnectionString1
connectionString =Data Source = XXXXXX\SQLSERVER2008;初始目录= esResearch;持久安全信息= True;用户ID = XXXXXX; = XXXXXX
providerName =System.Data.SqlClient/>
< add name =esResearchModels.Properties.Settings.esResearchConnectionString2
connectionString =Data Source = XXXXXX\SQLSERVER2008;初始目录= esResearch;用户ID = XXXXXX;密码= XXXXXX
providerName =System.Data.SqlClient/>
< / connectionStrings>
我想我不需要所有的字符串,但它至少工作。这行用于designer.cs
base(global :: esResearchModels.Properties.Settings.Default.esResearchConnectionString2,mappingSource)
我已经在asp.net/mvc上完成了电影示例项目,并使用了这个连接字符串
Web.config:
< ; connectionStrings>
< add name =ApplicationServices
connectionString =data source = .\SQLEXPRESS; Integrated Security = SSPI; AttachDBFilename = | DataDirectory | aspnetdb.mdf; User Instance = true
providerName =System.Data.SqlClient/>
< add name =MovieDBContext
connectionString =data source = .\SQLEXPRESS; Integrated Security = SSPI; database = Movies; User ID = sa; password =
providerName =System.Data.SqlClient/>
< / connectionStrings>
任何想法?
有这么多不同的连接字符串可用:
一般(Windows身份验证):
SqlConnection sql = new SqlConnection(Data Source = .\\SQLEXPRESS; Initial Catalog = database; Integrated Security =True);
(SqlServer身份验证):
SqlConnection sql = new SqlConnection(Data Source = .\\SQLEXPRESS; Uid = sa; password = sqlserver; database = databasename);
如果您想了解更多有关连接字符串的信息,请访问:
http: /www.connectionstrings.com
I decided to transfer my project from work to home and I am having some trouble with the connection to the database. This one works on work:
web.config:
<connectionStrings> <add name="ApplicationServices" connectionString="Data Source=XXXXXX\SQLSERVER2008;Persist Security Info=true;Initial Catalog=esResearch;User ID=XXXXXX; Password=XXXXXX" providerName="System.Data.SqlClient" /> <add name="esResearchConnectionString" connectionString="Data Source=XXXXXX\SQLSERVER2008;Initial Catalog=esResearch;Persist Security Info=True;User ID=XXXXXX;Password=XXXXXX" providerName="System.Data.SqlClient" /> </connectionStrings>
app.config:
<connectionStrings> <add name="esResearchModels.Properties.Settings.esResearchConnectionString" connectionString="Data Source=XXXXXX\SQLSERVER2008;Initial Catalog=esResearch;Persist Security Info=True;User ID=XXXXXX" providerName="System.Data.SqlClient" /> <add name="esResearchModels.Properties.Settings.esResearchConnectionString1" connectionString="Data Source=XXXXXX\SQLSERVER2008;Initial Catalog=esResearch;Persist Security Info=True;User ID=XXXXXX;Password=XXXXXX" providerName="System.Data.SqlClient" /> <add name="esResearchModels.Properties.Settings.esResearchConnectionString2" connectionString="Data Source=XXXXXX\SQLSERVER2008;Initial Catalog=esResearch;User ID=XXXXXX;Password=XXXXXX" providerName="System.Data.SqlClient" /> </connectionStrings>
I guess I do not need all those strings but it works atleast. And this line is used in designer.cs
base(global::esResearchModels.Properties.Settings.Default.esResearchConnectionString2, mappingSource)
I have done the movie sample project on asp.net/mvc and used this connectionstring and this one works on my computer at home.
Web.config:
<connectionStrings> <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /> <add name="MovieDBContext" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;database=Movies;User ID=sa;password=" providerName="System.Data.SqlClient"/> </connectionStrings>
Any ideas?
解决方案There are so many different connection strings are available:
General(Windows Authentication):
SqlConnection sql=new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=database;Integrated Security="True");
(SqlServer Authentication):
SqlConnection sql=new SqlConnection("Data Source=.\\SQLEXPRESS;Uid=sa;password=sqlserver;database=databasename");
If you want to know more about connection string, go to:
http://www.connectionstrings.com
这篇关于web.config中的连接字符串无法连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!