No I dont get the error when "I" test it, but then we have new networking cable in this building. I KNOW its a hardware issue as we can try to connect to the SQL Server and we will get "General Network Error"....thats pretty a convincing error. Thats from the MSSQL Management Consule too.
Jeremy -----Original Message----- From: Myles Penlington <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thu, 28 Aug 2003 10:05:47 +1200 Subject: RE: [DUG]: Restoring Lost Connections > J, > Only what I first said last week about it. And I would doubt that the > issue > is hardware (read I would be 100% certain). > > I think perhaps you should include an exception tracker/trace tool in > your > program so you can get some additional info on the the problem when it > happens. ie Create a debug build. eg Like this one > http://www.madshi.net/ > <http://www.madshi.net/> > > Does it ever happen during your testing of the app? > > Myles. > > -----Original Message----- > From: Jeremy Coulter [mailto:[EMAIL PROTECTED] > Sent: Thursday, 28 August 2003 08:28 > To: Multiple recipients of list delphi > 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/
