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
------------------------------------------------------------------------
