[freetds] How to subscribe Microsoft Sql server

Eric Yin xiaobiaoyin at outlook.com
Mon Sep 5 06:23:48 EDT 2016


Hi Frediano


    Thanks for pointing out that FreeTDS supports query notification for ODBC.

But now, I just use the DB-Library  example to query MS SQL server.

(http://www.freetds.org/userguide/samplecode.htm)

So my question is:

Does DB-Library APIs support query notification?

or is there a workaround way to subscribe MS SQL server using DB-Library APIs.

Any suggestions are welcome.


Thanks in advance


Cheers

Eric

DB-Library for the Tenderfoot - FreeTDS.org<http://www.freetds.org/userguide/samplecode.htm>
www.freetds.org
Example 11-3. Sample Code: DB-Library prolog. extern char *optarg; extern int optind; const static char syntax[] = "syntax: example -S server -D db -U user -P passwd ...





________________________________
From: FreeTDS <freetds-bounces at lists.ibiblio.org> on behalf of Frediano Ziglio <freddy77 at gmail.com>
Sent: Wednesday, August 31, 2016 6:29 PM
To: FreeTDS Development Group
Subject: Re: [freetds] How to subscribe Microsoft Sql server

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.
[http://www.easysoft.com/images/easysoft/partners/hp/business-partner.jpg]<http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html>

SQL Server ODBC Driver - Easysoft<http://www.easysoft.com/products/data_access/odbc-sql-server-driver/index.html>
www.easysoft.com
SQL Server ODBC driver for Microsoft SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL ...



>
>     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<http://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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list