且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用c#连接到远程计算机中的数据库SQL Server 2008

更新时间: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