Skip to Content.
Sympa Menu

freetds - Re: Polling tables?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: Polling tables?
  • Date: Wed, 4 Sep 2002 20:53:50 -0400 (EDT)


On Wed, 4 Sep 2002, Brian Bruns wrote:

> Not that I'm aware of. With Sybase you may be able to use replication
> server to monitor the transaction log and deliver the transaction to a
> bogus server using either OpenServer or libtdssrv. This is all rather
> theoretical at the moment though since I don't think it's ever been done
> ;-)
>
> the other options would be a pass thru server that the client connected to
> (ala tdspool) before being passed to the real server to intercept the
> call, or updating the table via a stored procedure that could then do some
> sort of RPC thing yet to be worked out.
>
> We use Sybase extended stored procedures (C stored procs with system
> 11.5 and above) to do the above type situation. Not sure if MS has
> anything resembling that.

Sure. That's what triggers are for.

>
> Brian
>
> On 5 Sep 2002, James Cameron wrote:
>
> > FreeTDS user query ... is there a way to have the SQL server tell me
> > when a table or row has been modified?
> >
> > At the moment, I place the SELECT in a loop, with a few seconds of
> > sleep(), but that's a bogosity ... I hate polling; it creates load and
> > still has a response delay. Is there a way I can wait for an UPDATE or
> > INSERT by another connection on a particular table?
> >
> > SELECT @@VERSION
> >
> > Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37
> > Copyright (c) 1988-1998 Microsoft Corporation Enterprise Edition on
> > Windows NT 4.0 (Build 1381: Service Pack 6)
> >
> >
>
>
> ---
> You are currently subscribed to freetds as: [bkline AT rksystems.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page