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
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.