[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] How to subscribe Microsoft Sql server
From:       Xiaobiao Yin <xiaobiaoyin () outlook ! com>
Date:       2016-08-31 10:38:00
Message-ID: KL1PR02MB128572E292878D9B258DBF3EE8E30 () KL1PR02MB1285 ! apcprd02 ! prod ! outlook ! com
[Download RAW message or body]

Great!

I will have a try.

________________________________
From: FreeTDS <freetds-bounces@lists.ibiblio.org> on behalf of Frediano Ziglio \
                <freddy77@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@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@lists.ibiblio.org> on behalf of Frediano Ziglio \
>                 <freddy77@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@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@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]