我写了一个windows数据库程序,连接SQL数据库,在装了.NET fRAMEWORK 的客户端连接数据库提示我"远程主机强迫关闭一个现有连接"
是怎么回事呀..代码如下:
请大家指教一下.
我又试了,从装了vs2005的电脑中运行程序连接客户端(装了sql2000)的,可以正常连接.private void btConnect_Click(object sender, EventArgs e)
{
if (ConnectToSqlDataBase() == true)
{
MessageBox.Show("数据库测试成功!");
}
}
private Boolean ConnectToSqlDataBase()
{
strServer=txtServer.Text ;
strDataBase=txtDataBase.Text ;
strUserId=txtUserId.Text ;
strPassWord=txtPassword.Text;
System.Data.Common.DbConnectionStringBuilder dbbuild = new System.Data.Common.DbConnectionStringBuilder();
dbbuild.Clear();
dbbuild.Add("Data Source", strServer);
dbbuild.Add("Initial Catalog", strDataBase);
dbbuild.Add("User ID", strUserId);
dbbuild.Add("Password", strPassWord);
dbbuild.Add("integrated security", false);
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = dbbuild.ConnectionString;
try
{
sqlconn.Open();
return true;
}
catch (Exception Err)
{
MessageBox.Show(Err.GetBaseException().ToString());
return false;
}
}
是怎么回事呀..代码如下:
请大家指教一下.
我又试了,从装了vs2005的电脑中运行程序连接客户端(装了sql2000)的,可以正常连接.private void btConnect_Click(object sender, EventArgs e)
{
if (ConnectToSqlDataBase() == true)
{
MessageBox.Show("数据库测试成功!");
}
}
private Boolean ConnectToSqlDataBase()
{
strServer=txtServer.Text ;
strDataBase=txtDataBase.Text ;
strUserId=txtUserId.Text ;
strPassWord=txtPassword.Text;
System.Data.Common.DbConnectionStringBuilder dbbuild = new System.Data.Common.DbConnectionStringBuilder();
dbbuild.Clear();
dbbuild.Add("Data Source", strServer);
dbbuild.Add("Initial Catalog", strDataBase);
dbbuild.Add("User ID", strUserId);
dbbuild.Add("Password", strPassWord);
dbbuild.Add("integrated security", false);
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = dbbuild.ConnectionString;
try
{
sqlconn.Open();
return true;
}
catch (Exception Err)
{
MessageBox.Show(Err.GetBaseException().ToString());
return false;
}
}
这里面有图片
你检查一下服务器端
但是在客户端上,连接就连接不到了...
高手指教一下.
try
{
sqlconn.Open();
return true;
}
catch (Exception Err)
{
MessageBox.Show(Err.GetBaseException().ToString());
return false;
}
finnally
{
sqlconn.close();
}