An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Question

I get that error when I try to debug my program. Searched for this error but could not really figure it out on my own. Also when I try to connect my database I get this error "error: 26 - Error Locating Server/Instance Specified".

public DataTable ReadData(string st_proc, SqlParameter[] param)
{
    SqlCommand command = new SqlCommand();
    command.CommandType = CommandType.StoredProcedure;
    command.CommandText = st_proc;
    command.Connection = conn;
    if (param != null)
    {
        command.Parameters.AddRange(param);
    }
    SqlDataAdapter db = new SqlDataAdapter(command);
    DataTable dt = new DataTable();
    db.Fill(dt);
    return dt;
}

What is the connection here (-minus the actual ip and password) ? Is the server on separate network? Does it need vpn? — Arghya C, May 24 '15 at 14:13
`Data Source=(Localdb)\mssqllocaldb;AttachDbFilename=E:\Hotel\App_Hotel\DB_Hotel;Integrated Security=True;User Instance=True\DB_Hotel.mdf;Integrated Security=True;User Instance=True` I did not make it. @SonerGönül — Livoskodi, May 24 '15 at 14:13

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

Looks like you have got the connection string from some else's machine. Here Data Source=(Localdb)\mssqllocaldb; means it is pointing to "[Sql Server Express LocalDB 2014][1]". Make sure you have it installed on you machine. You can also try connecting to DataSource=(Localdb)\v11.0; which is "Sql server express 2012" and use it in your connection string. See if this works.

edited May 23 '17 at 12:05

Community

1
1

answered May 24 '15 at 14:58

vendettamit

14,315
2
32
54

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

1 Answers1