WebServer as a Service and Softmasters template

[Alberto]

Hi,
I´m trying to make the webserver exe a service.
I´m adding the NT service extention of the ABCfree templates.
It works ok but...
I have a process theta generates an excel sheet using the Softmasters Templates.
If I run the webserver as an exe it works ok but if I use it as a server nothing happens, no error no nothing, the process bar looks as its doin the excel sheet but nothing...
Any idea ?
Any other way I can run the webserver exe as a service avoiding a user to log in each time the server restarts?
THanks
Alberto

[rjmiller]

Michelis,

I use selfservice from capasoft... no, I don't work for them... works like a champ with virtually no config on my part.  Sorry, but I am not familiar with the ABCFree templates.

  RJ

[Alberto]

Thanks RJ

And you use Softmasters template to generate an excel sheet?
Because these is causing the problem. Not the ABCfree template.

Regards

[rjmiller]

No, I am not.  I didn't realize you had already ruled out the service template as a cause.

Sorry.

[Alberto]

Thanks,
It sounds like the excle Automation cant be used by a service...
Dont know...

[bshields]

Hi Alberto,

Try editing the service (in control panel / administrative tools / services).

Go to the "Log On" tab and tick the box "Allow service to interact with desktop".

Its only a guess, but the Softmasters Templates (which I've never used or seen or heard of!) is probably using DDE and im pretty sure thats not going to work in a service environment. Ticking that box "might" help.

Regards
Bill

[Alberto]

Thanks Bill,
I´ve tried this but... no luck at all...

[bshields]

Hi Alberto,

I did some homework and yes the problem is a service trying to talk to a DDE server.

So a solution may not be possible but you could try:

#1 on the same "Log On" tab, change it to use a user account (the account you are logged in via) and not the system account, make sure you also tick interact with desktop. Then start the program that is going to be accessed via DDE, then restart your service. See if it works.

#2 starting excel (well its DDE server via the API call CreateProcess() or CreateProcessAsUser(). This may involve hacking the template, and i suspect much pain.

Maybe you might want to consider going back to .CSV for your spreadsheet (if its just data and not formulas).

When you think about how DDE works its really not suitable in a server/service environment.

Regards
Bill

[Alberto]

Thanks Bill, you are awsome...
I recall this working ok in a 2003 server...
I will what you suggest a try
Thanks again!