FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

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