I'm trying to make a DataSnap server/client system.
Apart from a lot of other problems the most troublesome problem right now is that I am unable to reconnect a TSQLConnection after it has failed.
I have several TSQLConnections:
* Client -> DataSnap Server
* DataSnap Server -> Other DataSnap server
* DataSnap Server -> MySQL Database
All these connections will sometimes die. For example if the internet connection goes down or if one of the servers (MySQL/DataSnap) is restarted.
When this happens I will get an Exception and the current SQL query or server method fails. After it has failed I need to reconnect to the server, but I fail to see how it is possible to do that.
There is no method to reconnect and it doesn't reconnect on its own. It just continue to fail even after the server is back online.
So my to put it straight, my question is: How do I reconnect a dbExpress failed TSQLConnection / TDBXConnection??
I use C++ Builder XE2 Update 3