Jump to content


IUnknown

Member Since 15 Feb 2014
Offline Last Active Jun 16 2018 01:39 PM
-----

Topics I've Started

TCP Provider: An existing connection was forcibly closed by the remote host

25 May 2017 - 02:20 PM

Hi Boki,

 

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.