Wrox Home  
Search P2P Archive for: Go

  Return to Index  

dotnet_windows_app_design thread: Windows Services - ?integrate log file into Sql2k?


Message #1 by "Donald Carver" <dcarver@c...> on Sun, 22 Sep 2002 21:21:46
Hello .Net Gurus,

I hope someone can help me.

I've developed a windows 'FileWatcher' service to determine when an 
antivirus log file has been updated from NortonAntiVirus (NAV). I have > 
5,000 pc's on the LAN, and need to 

automatically inform the NAV administrator and users that a virus exists 
on a particular box, identified by IP address, user and pc name.

Presently, all my app does is write an event to the Event Monitor. It 
works.

What I need to do is to take data from the log, import it into a Sql2k 
table, do data manipulation with another Sql2k table, update a 3rd Sql2k 
table, send an email to the infected user, and finally disconnect the ip 
connection.. all done automatically based upon the FileWatcher event.

I'm brain blocked on how to accomplish this--

1. Should the data access / data manipulation code go directly into 
the 'FileWatcher_Created' code or should/could that event call 
another .net exe or class?

2. I prefer to use a separate app in order to provide my NAV 
administrator with GUI feedback - something not possible with a 
WindowsService. This would allow the NAV admin greater process 
control. 

Any help would GREATLY be appreciated.

Don C

  Return to Index