Hello friends. Let share with you an issue I am facing today.
I have an application that reads the state of a machinery each 5 seconds.
The machinery write its state in a MSSQL database.
public async void getstate()
{
SqlConnection conn = new SqlConnection("Server=sql11.hostinguk.net;Database=mydatabase;User Id=myuser;Password=mypwd;MultipleActiveResultSets=True;");
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT state FROM [mydbo] WHERE id='1', conn))
{
SqlDataReader sqlreader = cmd.ExecuteReader();
while (sqlreader.Read())
{
.......
}
sqlreader.Close();
}
conn.Close();
await Task.Delay(5000);
callGetState();
}
public void callGetState()
{
getstate();
}
The issue is that after some hours I get: "Unhandled exception. A transport-level error occurred while receiving results from the server. (provider: Session Provider, error: 19 - Could not use physical connection)."
I don't know how to solve it.
Any help will be very appreciated.