server app is not running properly when started as a service.

rbuser

Hi Nard,

I finally got my server and webapp running fine.
Remember I got the AutoSearch date not working with my
MySql database. I needed to set the database type to SybaseASA.
But I needed to set the database type first before creating the
template. If I change the database type afterwards it wont get saved
in the item blob field of the MySql database.

Now everything works ok when I run my serverapp.
However when I want to run the server as a service with
the RBWinServer then the AutoSearch date field wont work.
Every other Autosearch field works fine.
I tryed to build a Delphi service but the results are the same.

Any idea what this may cause?

Thnx, Pascal

nardmoseley

Try testing the server within the context of a standard Delphi application
rather than a service, that way you can use the Delphi debugger. (Perhaps
you have already done this).

If the server app works properly when run as a Delphi app, then it should
work properly when run from the Windows Service. The main difference between
the two is that the Windows Service typically runs under a different user
account.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

You should be able to use the exact same server application for the test
explained in my prior post. I think that is important.

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello Nard,

Yes, as a standard Delphi application everything works.
However when I start the same Delphi application as a service
with the tool RBWinService then the dates do not work.
I get an error message saying my query is wrong near the place
where the dates should be filled in. But they are empty.

Regards, Pascal

nardmoseley

Have not heard of any issues like this before. The main difference in
running the app from RBServices vs a standalone .exe is the user account
under which it is executing. When you include rsServerActiveX in the uses
clause it enables the server app to be launched and started as a remote
controlled .exe (i.e. out of process COM Server). RBServices, which is the
real windows service, runs your server.exe using Com remoting).



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Have you checked the Regional Settings for the default user?

Many machines get installed in such a way that the default user has US
settings even when some other locale was intended.

Have you tried running the service as the same user as the one you use
interactively?

Regards

Stuart

Stuart Seath
Seath Computer Services
stuart@seath.co.uk