[AccessD] detect network

Jim,

  Not sure if this will fit your needs or not, but how about issuing a shell
command with:

  Ping <address of server>  >netchk.txt

  Then open and parse netchk.txt.  You just need to look for the word
"reply".   If found, you have a physical connection at least to the server.

<<Or should we just try to hit the central DB at app start and trap the
error?  I don't want to generate an error if I don't have to.>>

  That's what I would do.  To many things can foul things up (ie. security)
beyond simply checking for a connection.  Of course, I suppose it depends on
what you meant by "a connection".

   But in the end result, it's your app that needs to carry out whatever
operation.  By the time you've done enough checking to verify that the app
will be able to perform whatever, you might as well have just tried it.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco
Sent: Thursday, June 19, 2003 8:33 AM
To: AccessD (E-mail)
Subject: [AccessD] detect network


We've got a data collection application that will be run on disconnected
laptops.  At least once a week the laptop users will come in to the home
office to dump the data they've collected into our central SQL database.
Does anyone have any code that will detect that the laptop is connected to
our network so we can point their connection to the central DB (as opposed
to their local DB)?  Or should we just try to hit the central DB at app
start and trap the error?  I don't want to generate an error if I don't have
to.

Thanks,

Jim DeMarco
Director of Product Development
HealthSource/Hudson Health Plan


****************************************************************************
*******
"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
****************************************************************************
*******

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com