Hi Stephen,
What do you mean by "they are reliant on SQL Server?"
If it is polling the database all the time, then surely you can just keep
retrying the server connection every x seconds or minutes.
If it is doing an occasional query, then it may be better to rewrite the
code so that it connects, queries, and disconnects from the server.
I don't know that you can claim dependency on the SQL Server service as a
reason for not making an application into a service. What happens if the
SQL Server is on another machine and you have no control over whether the
service is started or not?
Writing your application to be "clever" is probably the key to turning it
into a service.
Regards,
Bevan
----- Original Message -----
From: "Stephen Bertram" <[EMAIL PROTECTED]>
To: "Multiple recipients of list offtopic" <[EMAIL PROTECTED]>
Sent: Friday, July 04, 2003 8:24 AM
Subject: [DUG-OFFTOPIC]: Use of services
Hi All
We are about to convert a couple of applications into services so they can
run on unattended servers without requiring a valid logon.
However one of our developers has expressed concern as the applications are
reliant on SQL Server and he regards any application that is not self
reliant as a poor candidate for a service.
I would appreciate comments on limitations or experiences with services
which are reliant on database services.
TIA
Stephen
Disclaimer : This communication contains information that is confidential
and the copyright of enSynergy Limited or a third party. If you are not the
intended recipient of this communication please delete and destroy all
copies and telephone enSynergy Limited on +64 9 9205441 immediately. If you
are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of enSynergy
Limited. Any views expressed in this Communication are those of the
individual sender, except where the sender specifically states them to be
the views of enSynergy Limited. Except as required by law, enSynergy Limited
does not represent, warrant and/or guarantee that the integrity of this
communication has been maintained nor that the communication is free of
errors, virus, interception or interference.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe offtopic"
Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe offtopic"
Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/
