Devart Forums

Hi ,

We are inserting a large volume of records into a SQL server database table using a stored procedure.
The connection is a : TSQLConnection
The stored proc is a : TSQLStoredProc

The problem is as follows: At times the connection to the DB is lost
but the application still shows as being connected.

Is there perhaps some notification event that can be used to send feedback back to the application when a disconnection occurs?

Many thanks.

The TSQLConnection.AfterDisconnect event occurs after the connection is closed by calling the Close method. If the connection was broken, this event is not arised.
dbExpress driver doesn't allow to get information about disconnection occurrence directly. For this you should try to execute any simple query (like "SELECT 1"), and if error is not raised the connection is established.