I've written a very simple Windows service using Delphi/XE2. I'm
running WinXP/SP3.
Installing and starting the service works fine, but when I try to
connect to a database it fails.
The message in the event log is.
--------------------
Access violation at address 1001F266 in module 'fbclient.dll'. Write
of address 0000004C.
--------------------
In design mode (in the IDE) "Connect" succeeds.
The connect is attempted in the execute method (not during start service).
If I don't use the database (commenting out the connect, insert,
commit and disconnect) I can see the it works as expected from the
messages it writes to the application event log.
Should I run it as a specific user (or the default "Local System
account")? Should I check the "Allow service to interact with
desktop"? I haven't yet tried this one.
Will this be different if I put the service on Win2008/R2 (server).

Is there anything "special" that one must do to make database access
work in the service? (I think the answer is "Yes" - but what?)


--
TiA
Aage J.