I suggest that for beginning you leave existing VB/SQL code as is. You can change it later if you find any advantages. Now the beginning point is need to find a way to check for a wireless connections starts. If you want to use 24x7 Scheduler you can write a small script job running every 10 minutes and consisting of several lines of code that use the Ping statement to test for network connectivity. It could ping for example your server computer if the result is successful assume network is up and it can then start your VB program. However this approach requires special care for when to start the program, what if it has been started during previous check? Here 24x7 Event Server comes really handy. You can use several types of event monitors to test for network connectivity near real time. "RAS connection start" event can be used as best fit. You can also use event log monitoring event, process monitoring event and probably other to indirectly monitor for wireless connection state. Hope that helps. : Hi Folks
: I am a newbie to this program and would appriciate some advice to point me in
: the right direction.
: I have written a datalogging/blackbox program for a train using VB and MySQL.
: What I would like
: to happen is every 10 minutes the program would check to see if a wireless
: network connection
: was available (train in maintenance workshop), if connection available then
: run a small VB app that
: moves all the data from the database since the last download to a central
: database.
: Where should I start and should I move my existing VB/SQL code into 24X7 or
: leave it as is???
: I know this is vague but instead of waisting hours on all the posible options
: why not ask the question?
: Regards
: SD
|
