I guess you are running in a terminal emulator...
If so, the easiest way is to see if the emulator itself has some command
sequence that allows running of local windows commands. Products such as
Termite and Viaduct etc have this functionality.
You *can't* do something like this in your databasic code:
EXECUTE CHAR(255):'snotepad xxx.dat'
This will run notepad, but without a user interface, and on the server.
So largely useless!
I've considered a few solutions to this in the past - one of which was
to run a vb program that constantly polls a directory on the server
(before I get flamed you can't use the filewatcher functions in
vb.net
for remote directories...) and put some sort of command queue that is
written from within your software - this is inefficient but works...
Another alternative is a sockets based approach, with a similar program
running on the server, which does use filewatcher to monitor a series of
files which are the command queue, and have a small socket based server
that runs on each PC to run the command. Again, pretty straightforward
to write in
vb.net (which is my chosen development language).
I think it is possible in a Windows domain to run a program remotely,
but I'm not sure how this works - we don't rely on our customers having
domains set up properly so I've never investigated this.
There are lots of similar approaches, including message queuing.. All
of which will work. The trick is to get the command from the server
back to the client PC.
Food for thought I hope..
Regards
Simon Verona
Dealer Management Services Ltd
The Old Cross
Woodfall Lane
Low Bradfield
S6 6LB
Tel: 0870 080 2300
Fax: 0870 169 6747
Email:
si...@dmservices.co.uk