auto reconnect to sql-database on connection loss
-
wrote on 8 Mar 2020, 18:48 last edited by
Hey guys,
I have an application which is connected 24/7 to a MS-SQL database.
If for some reason the connection is gone (i.e. server-restart) the client is woring anymore.
Is there a global method to detect a lost connection and to restart it?I don't want to handle every execute statement individually.
THX
mts -
Hi,
You should add which driver you are using to connect to that database as well as OS and Qt version.
-
wrote on 8 Mar 2020, 18:54 last edited by themts 3 Aug 2020, 18:55
I'm using the odbc-driver for linux (FreeTDS).
QT 5.12 -
wrote on 8 Mar 2020, 19:16 last edited by
Hi, I had more or less the same problem, and instead of trying to keep the connection alive to the server, I resorted to a polling approach, i.e. say every 5 minutes, I'd close all active connections, close the database, open the database again and reestablish the queries (this depends of course how often you can accept loss of contact, for example a heartbeat-monitor in a hospital, in this case 5 minutes is not acceptable).
1/4