I use grid: TNextDBGrid (5.9.85) bound to ds: TDataSource which is bound to rs: TADODataSet.
Time to time rs component queries SQL Server and fetches the results to the grid.
However... when the connection between by application and SQL Server is broken, grid cannot recover the broken connection.
The exception I get is on the attached screenshot: TCP Provider: An existing connection was forcibly closed by the remote host.
So far I do not know how to recover it programmatically without loosing the grid's functionality. Now I have to close the form and re-run my application.
I am also not sure which particular component causes this exception.
I would be very grateful if someone helps me to debug this exception and find an option to properly handle it to reinstate the connection without losing grid connectivity.