sql connection.open() exception

Question

I am new in .net and in this i am working on windows form application. I am trying to connect my application to visual studio service based database. I am simply writing a code behind submit button.

private void button1_Click(object sender, EventArgs e)
{
     SqlConnection con = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\\Users\\mudasir\\Documents\\Visual Studio 2012\\Projects\\Medical_Store_System\\Medical_Store_System\\MSS_database.mdf;Integrated Security=True");
      con.Open();
      if (con.State == ConnectionState.Open)
      {
          textBox1.Text = "Congrats";
      }
      else
          textBox1.Text = "Sorry";
          con.Close();
}

On con.open(); i met with an exception that shows

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

Please give me a simplified answer and solution because i am new to these things.

a simplified answer would be, something is wrong with your connection string — Jonesopolis
– Jonesopolis, Commented Feb 12, 2014 at 18:46
Try using SqlLocalDB Utility technet.microsoft.com/en-us/library/hh212961.aspx — Milen
– Milen, Commented Feb 12, 2014 at 19:09

Shiva · Accepted Answer · 2018-03-27 05:25:58Z

3

You are missing a \ in the connection string to escape the \ for (LocalDB)\version. So update it like so.

SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\mudasir\\Documents\\Visual Studio 2012\\Projects\\Medical_Store_System\\Medical_Store_System\\MSS_database.mdf;Integrated Security=True");

edited Mar 27, 2018 at 5:25

answered Feb 12, 2014 at 18:50

Shiva

21.1k15 gold badges88 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql connection.open() exception

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related