PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
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
Connect yourself…
Marlus Mair
#1
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?
Report
0
0
Andrea Chiadò Piat
#2
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
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text