R
RobbieDotNet
Guest
Hello,
we have a VB.NET application and SQL DB. If the user leaves his laptop for a period of time and if the laptop goes to sleep and the application left open, the user gets an error "A Transport-level error has occured when receiving results from the server" when he comes back and try to use the application (run the report for example) again which pulls data from SQL db. But if he runs the report again, he does not get an error.
In our code, we check if the connection is broken or closed, if so we open the sql connection again.
How can we solve this issue?
If SQLConnection.State = ConnectionState.Broken Then
SQLConnection.Close()
InitSQLConnection()
End If
If SQLConnection.State = ConnectionState.Closed Then
InitSQLConnection()
End If
Continue reading...
we have a VB.NET application and SQL DB. If the user leaves his laptop for a period of time and if the laptop goes to sleep and the application left open, the user gets an error "A Transport-level error has occured when receiving results from the server" when he comes back and try to use the application (run the report for example) again which pulls data from SQL db. But if he runs the report again, he does not get an error.
In our code, we check if the connection is broken or closed, if so we open the sql connection again.
How can we solve this issue?
If SQLConnection.State = ConnectionState.Broken Then
SQLConnection.Close()
InitSQLConnection()
End If
If SQLConnection.State = ConnectionState.Closed Then
InitSQLConnection()
End If
Continue reading...