bizhanmp
پنج شنبه 26 اردیبهشت 1387, 13:13 عصر
من وقتی میخوام به SQL متصل بشم خطا می گیره .اگه لطف کنید علت خطا را بهم بگید خیلی
ممنون میشم.
کد برنامه را در زیر نوشتم جلوی خطی که خطا داده هم ستاره گذاشتم .
//------------------------------error--------------------------------------------\\
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 allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
//--------------------------------------------------------------------------------\\
public partial class crs_form : Form
{
static SqlConnection con = new SqlConnection(
"server=MP-CCED49F5A13F; database=selectunitdb; integrated security=SSPI");
SqlDataAdapter dadp = new SqlDataAdapter("", con);
DataSet dst = new DataSet();
SqlCommand sqlcom = new SqlCommand("", con);
public crs_form()
{
InitializeComponent();
}
private void crs_form_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
dadp.Fill(dst); **********
dataGridcrs.DataSource = dst;
dataGridcrs.DataMember = "crs_table";
}
}
ممنون میشم.
کد برنامه را در زیر نوشتم جلوی خطی که خطا داده هم ستاره گذاشتم .
//------------------------------error--------------------------------------------\\
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 allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
//--------------------------------------------------------------------------------\\
public partial class crs_form : Form
{
static SqlConnection con = new SqlConnection(
"server=MP-CCED49F5A13F; database=selectunitdb; integrated security=SSPI");
SqlDataAdapter dadp = new SqlDataAdapter("", con);
DataSet dst = new DataSet();
SqlCommand sqlcom = new SqlCommand("", con);
public crs_form()
{
InitializeComponent();
}
private void crs_form_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
dadp.Fill(dst); **********
dataGridcrs.DataSource = dst;
dataGridcrs.DataMember = "crs_table";
}
}