dotnet_windows_app_design thread: Windows Services - ?integrate log file into Sql2k?
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