VS2010链接sql2005数据库,出现error26
小弟最近在研究sql2005数据库,在进行数据库连接前,我用sql server management studio在Debug文件夹内创建了一个数据库(因为是测试,所以命名123),进行链接后,出现了error: 26 - 定位指定的服务器/实例时出错问题,请问这个问题应该如何解决?
附上代码
public partial class Form1 : Form
{
SqlConnection occ = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\123.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand ocm;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
occ.Open();
string sql = "select * from userinfo where Login=@log";
//ocm = new OleDbCommand(sql, occ);
ocm = new SqlCommand(sql, occ);
ocm.Parameters.AddWithValue("@log", tbuser.Text.ToString());
//OleDbDataReader ldr = ocm.ExecuteReader();
SqlDataReader ldr = ocm.ExecuteReader();
if (ldr.Read())
{
ldr.Close();
}
occ.Close();
}
}