Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to subscribe Microsoft Sql server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] How to subscribe Microsoft Sql server
  • Date: Wed, 31 Aug 2016 11:29:12 +0100

FreeTDS supports query nofitications for ODBC. Just use a recent version.

Frediano


2016-08-31 11:22 GMT+01:00 Xiaobiao Yin <xiaobiaoyin AT outlook.com>:
> Hi Frediano
>
>
> Thank your for timely reply.
>
> For query notifications, it depends a SQL Server ODBC
> driver<http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html>
> which is not free.
>
> For trigger, I need to implement a program in windows to subscribe the
> notification
>
> and then transform this information to Linux. This might be a backup method.
>
>
> Is there a way to use open source to implement this requirement?
>
>
> Thank
>
> ________________________________
> From: FreeTDS <freetds-bounces AT lists.ibiblio.org> on behalf of Frediano
> Ziglio <freddy77 AT gmail.com>
> Sent: Wednesday, August 31, 2016 4:39 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] How to subscribe Microsoft Sql server
>
> 2016-08-30 23:15 GMT+01:00 Xiaobiao Yin <xiaobiaoyin AT outlook.com>:
>> Hi Experts
>>
>>
>> I am very new to FreeTDS and SQL server.
>>
>> so far I can connect the MS SQL server 2005 from CentOS 7.2 using C
>> program.
>>
>>
>> My requirement is that if the SQL database changed (such as insert
>> ,delete or update some items),
>>
>> is there a way to know this change?
>>
>>
>> After looking through the APIs, I found there is no such APIs to
>> subscribe specified SQL database table.
>>
>> Generally, I need to polling this specified table and see if the
>> return results is the same as the last query, but it
>>
>> seems a little bit complex and no efficiency.
>>
>>
>> So my question is:
>>
>> Is there an API to subscribe specified table in SQL server database.
>>
>>
>> Any comment and hint is welcome.
>>
>> Thanks in advance.
>>
>> Eric
>>
>
>
> One option is query notifications, for instance see
> http://www.easysoft.com/support/kb/kb01069.html.
> How do I use SQL Server Query Notifications from Linux and
> ...<http://www.easysoft.com/support/kb/kb01069.html>
> www.easysoft.com
> Query notifications, introduced in SQL Server 2005, allow an application to
> request a notification from SQL Server when the results of query change.
>
>
>
> The other option is triggers, see
> https://msdn.microsoft.com/en-us/library/ms189799.aspx.
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page