PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → [WD25] Nativ MSSQL connection lost
[WD25] Nativ MSSQL connection lost
Started by Marlus Mair, Apr., 08 2021 10:27 PM - 1 reply
Posted on April, 08 2021 - 10:27 PM
Hi,

i have an Windows Service made in WD25 that use native MSSQL connector to get the data from an other server. If the connection lost because the remote server was down or the network connection was down the service crashs. Its there a way to check conection lost and reconnect the DB after the DB server is comming up?
Registered member
54 messages
Popularité : +2 (2 votes)
Posted on April, 09 2021 - 12:51 PM
Hello Marlus,
probably you can test if your connection is ok using a read-test in a WHEN EXCEPTION mechanism
https://help.windev.com/en-US/…
If no exceptions, your connection is ok and you can proceed, otherwise [do some other code]

Hope this helps
Andrea