Reestablish broken connection after sleep

From: Michael Tissington (michael_at_nospam.com)
Date: 11/27/04 

Date: Fri, 26 Nov 2004 17:05:56 -0800

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

  • Reestablish broken connection after sleep
    ... 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. ... all the ado objects are no longer valid - because the ...
    (microsoft.public.sqlserver.programming)
  • Re: Reestablish broken connection after sleep
    ... the connection open for the time taken to retrieve the data, ... >I have an application on a laptop that runs with several ADO objects open ... > If the application is running and the laptop goes to sleep ... all the ado objects are no longer valid - because the ...
    (microsoft.public.data.ado)
  • Re: Reestablish broken connection after sleep
    ... the connection open for the time taken to retrieve the data, ... >I have an application on a laptop that runs with several ADO objects open ... > If the application is running and the laptop goes to sleep ... all the ado objects are no longer valid - because the ...
    (microsoft.public.sqlserver.programming)
  • 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)