been there done that. Jeremy
-----Original Message----- From: "Nello Sestini" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thu, 28 Aug 2003 05:25:36 +0700 Subject: Re: [DUG]: Restoring Lost Connections > MessageIs it possible a DHCP assigned IP address lease is expiring > and your server address changes while you are using it? > > I have no idea how well that gets handled - presumably you > should (and probably do) have the SQL server assigned a static IP. > > maybe worth a look though ... > > > > -ns > http://www.roserox.co.th > > > ----- Original Message ----- > From: Jeremy Coulter > To: Multiple recipients of list delphi > 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 > > ----------------------------------------------------------------------- > - > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
