Local DB: “A network-related or instance-specific error occurred while establishing a connection to SQL Server.”

Question

I have already checked other topics regarding the matter and tried some of the standard solutions but nothing seems to work. My DB is local and I'm trying to connect, it is already created and saved in the folder Helpers with the name of localDB.mdf My code is:

public static List<ChatMessages> GetFromDatabase(string query)
    {
        List<ChatMessages> ImportedFiles = new List<ChatMessages>();
        string sql = @"Data Source=|DataDirectory|\Helpers\localDB;AttachDbFilename=\Helpers\localDB.mdf;Integrated Security=True";
        SqlConnection connection = new SqlConnection(sql);
        try
        {
            connection.Open();
            var check = connection.State;
            SqlCommand cmd = new SqlCommand(query, connection);
            var rdr = cmd.ExecuteReader();
            while (rdr.Read())
            {
                //stuff
            }
            connection.Close();
        }
        catch (Exception e) { MessageBox.Show("error: " + e); }
        var x = ImportedFiles;
        return ImportedFiles;
    }

Thanks for your time, Best regards

@Win the thing is that inside the Visual Studio it runs smoothly but when I export it does in my Personal Computer but not in another computer — Ricardo
– Ricardo, Commented Oct 19, 2016 at 11:42
For Code Migrations (update-database et al) see this answer. — Marc.2377
– Marc.2377, Commented Jul 31, 2018 at 21:17

Ricardo · Accepted Answer · 2016-10-19 22:01:48Z

5

Already found an answer. After attempting a lot of hypothesis like the ones suggested by @Win I found the answer. So:

Project > Add New Data Source > Choose the local DB And the connection string suggested was:

@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename=|DataDirectory|\localDB.mdf; Integrated Security = True"

The difference is in the MSSQLLocalDB and in the use of the environment variable.

answered Oct 19, 2016 at 22:01

Ricardo

4195 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Local DB: “A network-related or instance-specific error occurred while establishing a connection to SQL Server.”

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