Databases
StackOverflow2013
Postsdbo
PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
    primarykey
    data
    text
    <p>I just want to loop through the results in the database. That's all I am trying to do at this point! This is the error I get when I try to debug:</p> <blockquote> <p>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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)</p> </blockquote> <p>It points to this line:</p> <pre><code>// fill dataset into named table myAdapter.Fill(myDataSet, "Sent"); </code></pre> <p>Here is my whole code:</p> <pre><code> // get connection strings from app.config string conString = ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ConnectionString; // connection object SqlConnection myConn = new SqlConnection(conString); // create adapter SqlDataAdapter myAdapter = new SqlDataAdapter("select * from `Sent`", myConn); // create command builder SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter); // create dataset DataSet myDataSet = new DataSet(); // fill dataset into named table myAdapter.Fill(myDataSet, "Sent"); // query using linq IEnumerable&lt;DataRow&gt; results = from row in myDataSet.Tables["Sent"].AsEnumerable() select row; // enumerate through results foreach (DataRow row in results) { MessageBox.Show(row.ToString()); } </code></pre> <p>What can I do to fix this? Also, if anyone has an easier way to use databases in C#, I am open to your ideas because this has been ridiculous for me (manipulating a database in c#). Thank you for your help.</p> <p><strong>Update 6/29/12:</strong></p> <p>The following code works for me:</p> <pre><code> // get connection strings from app.config string conString = ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ConnectionString; // connection object SqlCeConnection myConn = new SqlCeConnection(conString); // create adapter SqlCeDataAdapter myAdapter = new SqlCeDataAdapter("select * from [Sent]", myConn); // create command builder SqlCeCommandBuilder myCommandBuilder = new SqlCeCommandBuilder(myAdapter); // create dataset DataSet myDataSet = new DataSet(); // fill dataset into named table myAdapter.Fill(myDataSet, "Sent"); // create new row DataRow newRow = myDataSet.Tables["Sent"].NewRow(); // set field vals newRow["sendTo"] = sendTo; newRow["subject"] = subject; newRow["message"] = message; // add new row to table myDataSet.Tables["Sent"].Rows.Add(newRow); // update database myAdapter.UpdateCommand = myCommandBuilder.GetUpdateCommand(); int updatedRows = myAdapter.Update(myDataSet, "Sent"); //MessageBox.Show("There were "+updatedRows.ToString()+" updated rows"); // close connection myConn.Close(); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1477388
    1. USuser1477388
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. This table or related slice is empty.
      1. VTDownMod
    1. COThe first thing you need to check is whether your connection string is OK and if it points to the right server/database.
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. USMiroslav Popovic
    2. COFirst step: read the message and act on it. Second step: Google the message.
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. USusr
    3. COI concur with @usr. The error message is very self-explanatory and, even if it isn't for some reason, a few seconds with Google turns up the answer to this really quickly. The problem is with your connection string or the SQL server itself. This question doesn't belong here. It is expected that you do at least some cursory research before asking a question here.
      singulars
      1. PONetwork-related or instance-specific error occurred while establishing a connection to SQL Server
      1. USdodexahedron
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload