Writing Service to move Data - Best method?

W

Weavaudio

Newcomer
Joined
Apr 9, 2003
Messages
2
Location
Choclate Town, USA
Basically I am writing a service to run on a Win2k server. This service will open a ODBC connection (Via ADO) to a Progress Database, query it, and if results are found, move the records into an Access database used for reporting.

I need this "hunt and transfer" to occur every two minutes. Should I use a timer and set it to connect every two minutes (is that long of a period possible?) or should I have it run all the time and have it "sleep" (how would I do that??)

Currently I have it in VB6 on NT 4 Workstation on the task shceduler every two minutes, but I really want this thing to be a service.


TIA for the help.....
 
You can't develop Windows Services in VB 6 unless you use 3rd party ActiveX controls. Doing it in .NET should be a breeze.
 
Back
Top