Re: ADO Broken Connection



> But in my situation, I cannot change a lot of these code right now, is
there
> a way to programmatically determine a network connection loss in the
> connection the next time I use the connection object?

Yes. Execute "SELECT 1".
It is the cheapest round-trip SELECT.
If the Connection is broken then an error will occur which you can trap.

Stephen Howe


.



Relevant Pages

  • Re: ADO Broken Connection
    ... the connection is wrapped, we can also use WMI to notify us of any network ... errors and close and open ADO connection internally. ... > a way to programmatically determine a network connection loss in the ...
    (microsoft.public.data.ado)
  • Re: OO Design induces an existential crisis
    ... domain, the way I understand it, so the connection is not obvious to me. ... I will take a look at some of the proposed literature, ... Thanks, Ilja ... Prev by Date: ...
    (comp.object)
  • Re: Public Folders between two Servers
    ... limited knowledge of SBS. ... Even me the total novice has found some major ... On the email issue would this be solved if we got our own connection and ... Prev by Date: ...
    (microsoft.public.windows.server.sbs)
  • Professional Womens Tennis Association like domain names for sale
    ... The womens professional Tennis web site is "www.wtatour.com" ... They get hundreds of thousands of hits per day. ... See the connection? ... Prev by Date: ...
    (rec.sport.tennis)
  • Re: connection dapn ss windows xp
    ... > de périphérique photo ou audio? ... Prev by Date: ...
    (microsoft.public.windowsxp.general)