We have a continuous task that checks a database table for the existence of unprocessed records, and if it finds any processes them. This is done without user interaction, and doesn't need a user interface. We have previously handled this by running a form on the console of the Server (started in the logon script of a user which is automatically logged in). However It would seem preferable to do this as a service.

Can Strataframe BOs be used in a service, and is there an example of how it is accomplished somewhere? I've had a look in the documentation, demos and forum but didn't find anything.

Peter

The reason that we do not have a sample is because there is not a whole lot to add past creating a service.  It is just a matter of adding the SF assemblies and then start programming as though it were a class library or a program without UI.

We have a UI console that talks to the service so that certain things can be setup, status seen, etc.  But as for the service, it is obviously non-UI (as you will want to be sure that it is...even if you intend for your service to "Interact with desktop").

But there really isn't a whole lot to add past that...just add your SF references and get to work.  One other piece of advice that I might share is that we used Http requests and responses versus having sockets open all of the time for communication between the client and server which has worked out very nicely, but this doesn't have anything to do with SF...just a suggestion.

I'm not sure that I'm out of the woods yet, but I've got my service to install, start and stop, now I only have to get it to do something useful.

I've copied the SetSources out of the AppMain of one of my StrataFrame projects, put it in my service.vb, and called it directly from the sub main (in the designer code). I haven't got anything from the database yet, but i found the error in the event log about the account NT AUTHORITY\LOCAL SERVICE not having access to MSSQL strangely encouraging.

Peter