TMSChangeNotification and NativeClient

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
OlliWW
Posts: 25
Joined: Mon 25 Mar 2013 17:03

TMSChangeNotification and NativeClient

Post by OlliWW » Tue 17 Sep 2019 13:47

Hi,

According to:
https://www.devart.com/sdac/docs/devart ... cation.htm
You have to use the SQL Native Client Provider to get Change Notifications working.

But Microsoft says that the native client is deprecated and you should use the MsSQL Ole DB Driver:
https://docs.microsoft.com/en-us/sql/re ... erver-2017

Are changenotifications supported with ole db driver, too? If no: Is it planed for the future? Is there an alternative to change notifications with native client? Since i'm implementing it right now in a new project i don't want to use methods that are deprecated since i'm developing a long term project.

Best regards

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: TMSChangeNotification and NativeClient

Post by Stellar » Wed 18 Sep 2019 06:05

The providers prNativeClient(SQL Server Native Client), prMSOLEDB(Microsoft OLE DB Driver for SQL Server) and prDirect(Connect to SQL Server directly via TCP/IP) support automated notifications about events on the server side (TMSChangeNotification).
Thank you for the information. We'll change the requirements for using TMSChangeNotification in our documentation.

Post Reply