Myles. You seem to be missing the point. We have already confirmed its a hardware issue. Wether I can ping the SQl box is irrleivant. That fact is, it can be fine for days, and then you go into the Management console and one time it will give you a network error. This is outside of Delphi, and can happen on multiple machines
The issue IS when the network connection is lost, how do I make it reconnect WITHOUT having to restart the application. Jeremy -----Original Message----- From: Myles Penlington <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thu, 28 Aug 2003 10:23:16 +1200 Subject: RE: [DUG]: Restoring Lost Connections > J, > Can you ping the SQL server machine? > If you can - revert to software issue/config issue. > M > > -----Original Message----- > From: vss [mailto:[EMAIL PROTECTED] > Sent: Thursday, 28 August 2003 10:21 > To: Multiple recipients of list delphi > Subject: RE: [DUG]: Restoring Lost Connections > > > 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/ > ----------------------------------------------------------------------- > ---- > 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/ --------------------------------------------------------------------------- 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/
