VB Forum / General / November 2004

¤ I would like to write a VB6 program that I can run as a service.
¤
¤ Basically, the service will scan a directory for file(s).
¤
¤ Once a file is found, it will INSERT the file into a SQL Server database.
¤
¤ It will then copy the file to an alternate location to be processed.
¤
¤ It will then delete the original file.
¤
¤ Anyone have any sample code for this?
¤
¤ Would I be better off learning VB.Net and writing program as a service?
¤

Yes. First, you can easily develop a Windows service in VB.NET without the restrictions and
workarounds with respect to VB 6.0. A project template is included for .NET.

In addition, .NET has a FileSystemWatcher class that should accomplish exactly what you are
attempting to do.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr
fsystemiofilesystemwatcherclasstopic.asp

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Subject: Build an NT Service in Visual Basic 6???
http://groups.google.com/groups?hl=en&lr=&th=50a99fbf4e713b9&rnum=1

More where that came from
Results 1 - 100 of about 250 for "create a service" -dotnet group:*.vb.*.
(5.98 seconds)
http://groups.google.com/groups?as_epq=create%20a%20service&as_eq=dotnet&safe=im
ages&as_ugroup=*.vb.*&as_scoring=d&lr=&num=100&hl=en

Creating a Watched Folder with FindChangeNotification
http://vbnet.mvps.org/index.html?code/fileapi/watchedfolder.htm