Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

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

edited March 2004 in Server
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

Comments

  • edited March 2004

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004
    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


  • edited March 2004

    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


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004
    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
This discussion has been closed.