----- Original Message -----
Sent: Thursday, August 28, 2003
03:28
Subject: [DUG]: Restoring Lost
Connections
Hi
All.
As some of you may
remember from late last week I put on a post about some issues that I thought
were relasted to dodgy networking cable or a bit of dodgy hardware in out SQL
server, and that progressed into Static arrays and all
sorts.
Ok, well, this has
resolved some issues, BUT there is still a bit of dodgy hardware somewhere as
sometime we will get lost connections still.
SO, the user gets
an error "Lost Conection" there something like that, and I have code that is
MEANT to reconnect to the DB if it does diconnect, this is in an ADOConnection
comp. but the code never seems to fire, and even if I try to trap the error
using the ADOConnection comp, it still does not always
trigger.
BUT I should
larify one thing. The forms are all static, and the error happens when the
user tries to update or insert the data.
The events are,
press button, build SQL string, fire the query....its at this point that the
user gets notified of the lost connection.
I of course get
panicy phone calls from users who dont want to loose their data etc. etc.
etc.
This sometimes
only happens once a week, sometimes 2, depending on whats going
on.
Anyone got some
suggestions?
Cheers,
Jeremy
Coulter
------------------------------------------------------------------------
All email scanned with Nortons
Antivirus 2003
------------------------------------------------------------------------
