PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV 2024 → [WD25] Nativ MSSQL connection lost
[WD25] Nativ MSSQL connection lost
Iniciado por Marlus Mair, 08,abr. 2021 22:27 - 1 respuesta
#1
Publicado el 08,abril 2021 - 22:27
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?
#2
Miembro registrado
54 mensajes
Popularité : +2 (2 votes)
Publicado el 09,abril 2021 - 12:51
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
→ Volver a WINDEV 2024