Hi there,

online-updating the client part of an EDB installation is easy - in myapp.exe I start updater.exe and close myapp.exe. updater.exe is asking for local admin privileges, downloads new version of myapp.exe, replaces it with the old one, and restarts it. No big deal.

But what to do with the server? Usually the local user doesn't have admin privileges on the server machine, so I cannot stop/start the server service, and cannot write into the directory edbsrvr.exe is in. I could ask for the admins username/password and store it. Problem 1: I don't think admins would like that. Problem 2: they could change their password.

Since edbsrvr.exe as a service already has admin privileges, it would be really cool if I had a SQL command like "RUN serverupdate.exe"...

How do others solve the issue of a fully automatic online update for an EDB client/server installation?

Thanks in advance,

Heiko

Heiko,

<< online-updating the client part of an EDB installation is easy - in
myapp.exe I start updater.exe and close myapp.exe. updater.exe is asking for
local admin privileges, downloads new version of myapp.exe, replaces it with
the old one, and restarts it. No big deal.

But what to do with the server? Usually the local user doesn't have admin
privileges on the server machine, so I cannot stop/start the server service,
and cannot write into the directory edbsrvr.exe is in. I could ask for the
admins username/password and store it. Problem 1: I don't think admins would
like that. Problem 2: they could change their password.

Since edbsrvr.exe as a service already has admin privileges, it would be
really cool if I had a SQL command like "RUN serverupdate.exe"... >>

Noted.

<< How do others solve the issue of a fully automatic online update for an
EDB client/server installation? >>

I think most customers that want something like this end up modifying the
edbsrvr.dpr project to add the relevant code.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

thanks for your reply.

<< Noted. >>



<< I think most customers that want something like this end up modifying the edbsrvr.dpr project to add the relevant code. >>

Is there a way to communicate between the client and the server engine? If not, maybe you could note that something like an Engine.SendMessage procedure and an Engine.onMessageReceive event would also be cool

Heiko

Heiko,

<< Is there a way to communicate between the client and the server engine?
If not, maybe you could note that something like an Engine.SendMessage
procedure and an Engine.onMessageReceive event would also be cool >>

Yes, absolutely:

Client:

http://www.elevatesoft.com/manual?action=viewmethod&id=edb2&product=delphi&version=7&comp=TEDBSession&method=CallRemoteProcedure

Server:

http://www.elevatesoft.com/manual?action=viewevent&id=edb2&product=delphi&version=7&comp=TEDBEngine&event=OnServerProcedure

An even better option will be forthcoming when EDB's messaging is available.

Tim Young
Elevate Software
www.elevatesoft.com