title: How should I avoid MSSQL timeout?
body: <p>I have 2 programs:</p>
  
  <ul>
  <li>A server that produce data and insert it in MSSQL(written with C++ and use ODBC for connection).</li>
  <li>A client that read data from MSSQL and show it to the user(written in .NET(C#, VB) and use .Net SqlClient).</li>
  </ul>
  
  <p>Now my problem is when my server is running and insert data into MSSQL, my client can't select data from it or even sometime the connection will be failed. Currently I am running both server and client on a single machine but they should run on network! I try to increase <code>connection timeout</code> in my connection string and it work sometime but not always. My server load is not too high(may be one insert every second). So what is wrong in my server and what should I do to find the error?</p>