The same result can be accomplished by calling a subroutine that does
nothing other than return.
If it does not throw an exception, then the connection is alive.
==========================
Richard Nuckolls
Lynden Incorporated
18000 International Blvd, #601
Seattle, WA 98188
On Oct 4, 2007, at 8:42 AM, Kryka, Richard wrote:
Jef Lee wrote: I believe the IsActive property is not entirely
accurate...
From my tests, you are right about IsActive - it is the results of the
last connection (I think) and has nothing to do with the current
state.
I added a timer function to our VB front end that runs every 60
seconds
and just opens a file. If the connection has been lost, the open is
unsuccessful. We display a message informing the user that the
connection is broken and they need to log on again.
This function has almost no overhead and keeps users from spending
several minutes or more on a form, then discovering that nothing was
saved. It also solved the timeout issue where people would go into a
meeting or out to lunch and their connection would be timed out for
inactivity. The function runs from only from 6am to 8pm, their local
time. If users go home at night without logging out, their connection
is still logged out for inactivity instead of being connected all
night.
Dick Kryka
Director of Applications
Paragon Financial Services
a Division of Money Management International
303-632-2226
[EMAIL PROTECTED]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
