Skip to Content.
Sympa Menu

freetds - RE: [freetds] Freetds API query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Chris Underhill <chris AT tart.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Freetds API query
  • Date: Tue, 10 Jun 2003 20:42:43 -0000

On Tue, 2003-06-10 at 10:17, Michael Peppler wrote:

> Sybase has the XP server and also the syb_sendmsg() function that you
> could use for this sort of thing.

[Snip]

I once needed to do something similar for an order routing system on
MS/SQL server 7. The solution I came up with was to write an external
stored procedure, written in C, that sent a short appropriate message to
a specific multicast address to which all the relevant order routers
were listening. Based on the contents of that message the listeners
either ignored the message or performed a database lookup and acted
accordingly. This code was called by the insert/update order procedures,
though equally it could be done through an insert/update trigger etc.

We've since moved to Oracle where this was much less hassle to implement
using the built-in Java interpretor :-)

HTH,


Chris.





Archive powered by MHonArc 2.6.24.

Top of Page