[KLUG Members] triggering a program

[Adam Tauno Williams]

> Sorry for the obscure subject line.  Here's the problem:
> Box 1 is a Win box, I have no access to it.
> Box 2 is a Linux box and db server.  I have -some- access to it.
> Box 3 is a LAMP server, I have full access to it.
> Scenario: Box 1 uses ODBC to INSERT to a DB on Box 2.  
> Need: I need Box 2 to send information to Box 3 when that happens (real
> time).
> I can probably use Curl for Box 2 to talk to Box 3, but what would start
> it?

A "trigger", just as you suggested.  Have a trigger invoke a stored
procedure.  The stored procedure can make a SYSTEM(....) call just like
in PHP.

> Other ideas?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.kalamazoolinux.org/pipermail/members/attachments/20060216/101e582c/attachment.bin