This question is a follow up on my previous question:
Some of my customers still get once in a while an errormessage that the connection to the database server is lost. The given solution on my previous post to check the connection in a thread doesn't seem to work in all cases, so I'm looking for a new solution, or updated one.
Is there a way to add some properties, methods or events to TADOQuery and/or TADOConnection?
The moment a request or update is done this will then check if the connection is still valid and, if not, it tries to restart the connection. If it fails to reconnect, an error is shown and application needs to shut down.
Any other ideas are very welcome too.