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 22:47:57 -0000

On Tue, 2003-06-10 at 22:31, manoranjan_sahu AT agilent.com wrote:

> That's very similar to what I have been looking for.
> Would it be possible for you to be a little more detailed ?

Sure.

> My world has been mostly unix. My apologies if these questions are
> too trivial.

I too come from Unix background and this is the only winsock programming
I've ever done ;-) Fortunately it's very similar to the standard unix
socket api.

> Did you use sockets to send messages the from the C stored procedures ?

Yes - standard winsock calls. Look in the sql server documentation/msdn
for details on how you can create an "extended stored procedure" and
then look up using google etc. for info on creating simple winsock
applications and put the two together as detailed in the documentation
to generate a dll.

Finally you need a nice friendly sysadmin who trusts your code enough
that s/he's happy to load this dll into the server's address space and
create the procedure using sp_addextendedproc - afair if your code is
buggy/leaky, this can create rather a lot of fun with sql server
hangs/crashes etc. :-)

> How do you send messages from SQL server to unix boxes using database
> triggers. Does SQL server has any feature like that ? I couldn't find any..

Just have the trigger call the extended stored procedure, which will
send the message to the address that your unix servers are listening on.

HTH,


Chris.





Archive powered by MHonArc 2.6.24.

Top of Page