更新时间:2023-02-22 13:40:18
试试这个
在app.config文件中创建一个连接字符串
try like this
In app.config file create one connection string
<?xml version="1.0"?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" />
</startup>
<connectionStrings>
<add name="DBSqlServerConnectionstring" connectionString="Password=Your Password;Connection Timeout=0;Persist Security Info=False;User ID=userid;Initial Catalog=databasename;Data Source=servername;" />
</connectionStrings>
</configuration>
和访问权限这在您的表单中使用
and access this in your form using
public static string DBSqlServerConstringSQLAuth
{
get
{
return ConfigurationManager.ConnectionStrings["DBSqlServerConnectionstring"].ToString();
}
}
嘿,
请检查以下内容链接。
http://littletalk.wordpress.com/2008/03/21/an-error-has-occurred-while-establishing-a-connection-to-the-server-when -connecting到SQL服务器 - 2005年这个故障影响的可能,可以与引起由这事实是,下了默认的设置-SQL服务器不 - 不全部/ [ ^ ]
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10153.aspx [ ^ ]
谢谢
Hey,
Please check the following links.
http://littletalk.wordpress.com/2008/03/21/an-error-has-occurred-while-establishing-a-connection-to-the-server-when-connecting-to-sql-server-2005-this-failure-may-be-caused-by-the-fact-that-under-the-default-settings-sql-server-does-not-all/[^]
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10153.aspx[^]
Thanks