Re: Reestablish broken connection after sleep

From: Mary Bray (reply_at_tonewsgroup.com.NOSPAMPLEASE)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 15:19:51 +1100

This is actually not a good design. It is generally much better to only keep
the connection open for the time taken to retrieve the data, then close it.
If you are using persistent recordsets and are not making them client-side
and disconnected then you don't really have a good solution for the
environment (as you have discovered.) 

-- 
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"Michael Tissington" <michael@nospam.com> wrote in message 
news:%23BPAB1B1EHA.2856@TK2MSFTNGP15.phx.gbl...
>I have an application on a laptop that runs with several ADO objects open 
>at a given time (Connection, Recordset etc) - most all use client side 
>cursor.
>
> The database is on another machine.
>
> If the application is running (sitting idle) and the laptop goes to sleep 
> and then resumes, all the ado objects are no longer valid - because the 
> connection object is broken.
>
> Is it possible to monitor for an event on the connection object and re 
> establish it when the computer resumes so that any associated objects are 
> still valid?
>
> Thanks
>
> -- 
> Michael Tissington
> http://www.oaklodge.com
> http://www.tabtag.com
>
>
>

Relevant Pages

  • Re: Unsolvable windows networking problem
    ... Is the router security set to MAC Address Filtering? ... >> Wired connection to desktop running Windows XP Home ... >> Wired and wireless connection to laptop running ... >> There are 2 servers in domain NEWHOME on transport ...
    (microsoft.public.windowsxp.general)
  • Re: 1 way remote desktop
    ... I am using the local ip of the desktop as seen on my lan ... laptop = 192.168.0.3 ... also remote access connection mgr is up. ...
    (microsoft.public.windowsxp.work_remotely)
  • RE: Strange VPN Porblem
    ... I understand that one laptop can not access ... Please disable the XP firewall, and ensure there is no connection limit ... Please manually create a VPN connection via the following KB and then ... Try to access share folder via IP address (i.e. ...
    (microsoft.public.windows.server.sbs)
  • Re: home networking
    ... On the laptop Microsoft Firewall was active. ... On both computers I had to enable NetBIOS over ... Ethernet adapter Wireless Network Connection: ...
    (microsoft.public.windowsxp.network_web)
  • Re: Why is this Internet Connection Status in my System Tray
    ... One laptop uses the wireless connection and the other laptop ... If I disable 'internet gateway', even though wireless connection is still ...
    (microsoft.public.windowsxp.network_web)