Re: How to deal with broken server connection?
- From: "Del M" <Del.Murray@xxxxxxxxxxxxxx>
- Date: Fri, 5 Aug 2005 21:52:04 -0400
Where you catch it depends mostly on the type of program you are writing.
BUT .. the ADO connection object will often return "true" , thinking that it
is connected when in fact, it aint. Most of us get around that by not
testing to see if it is connected but by trying to run a querry that "does
nothing" .."select id from custmast where 1=2", or to call some cached
stored procedure that just tries to get one column from one row in a known
table. If it fails, you have no connection despite what the connection
object may say.
.
- References:
- How to deal with broken server connection?
- From: Richard Hayward
- How to deal with broken server connection?
- Prev by Date: Seek and soLastEQ
- Next by Date: Insert&Post Errorhandline Server based Client
- Previous by thread: How to deal with broken server connection?
- Next by thread: Re: How to refresh a single row from database?
- Index(es):
Relevant Pages
|