Re: how to kick off a Delphi exe from a stored procedure?
On Tue, 11 Mar 2008 10:13:18 -0000, Al <anugent@xxxxxxxxxxxxxx> wrote:
I would like to construct a stored procedure in SQL Server 2005 to do
all of these tasks, including kicking off the remote (Dephi) exe's. Can
I do this? If so, is there a way to make the stored procedure wait until
a given external program has finished executing before proceeding to the
next block of code?
Al,
Have you considered that you might have much more control if you "do it
the other way round"?
i.e. Have a controlling (Delphi) app which kicks off the Delphi exe's (or
includes them as sub-procedures) and calls the stored procedures as/when
necessary
(A stored procedure controlling/starting/waiting for *remote* Delphi exe's
is something I personally would avoid)
Inter-process communication (especially between processes on *remote*
machines and SQLserver) could be done via reading/writing a table in the
DB (not very "sexy" but, equally, not much to go wrong!)
--
Paul Scott
Information Management Systems
Macclesfield, UK.
.
Relevant Pages
- Query Hangs...
... We have a stored procedure that runs and grabs data from a remote ... If this happens while our stored procedure is running, ... CPU_PER_CALL to control this. ... I'm wondering what other ways there are to control the jobs hanging if ...
(comp.databases.oracle.misc) - Re: Query Hangs...
... We have a stored procedure that runs and grabs data from a remote ... If this happens while our stored procedure is running, ... I'm wondering what other ways there are to control the jobs hanging if ...
(comp.databases.oracle.misc) - Re: Corporate Web based email - threats
... We did a thorough analysis on iNotes and in summary found what you noted. ... legal reasons) that clean the remote PC's leftovers before logoff. ... You need end to end control - including the human at the remote keyboard ... lot of possibility to penetrate user sessions starting from stolen session ...
(Security-Basics) - Click
... Adam Sandler plays Michael Newman, experiencing the pathos that come trying to meet the simultaneous and contrary demands of a family and a career. ... Only the execution is new, albeit sometimes clumsy, which developed almost seamlessly from Newman's desire for a single remote unit to control the various electronic components and appliances in his home. ... These were the parts that felt like filler to me, as they lent nothing to anything, so the film at that point seemed like it was lacking something, that the filmmakers knew it, and they were hoping to hide it. ...
(rec.arts.movies.current-films) - Re: Click
... Sandler plays Michael Newman, experiencing the pathos that come trying ... almost seamlessly from Newman's desire for a single remote unit to ... control the various electronic components and appliances in his home. ... You are lulled into thinking the rest of the movie will be more of the ...
(rec.arts.movies.current-films) |
|
