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
TMSChangeNotification and NativeClient
Re: TMSChangeNotification and NativeClient
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.
Thank you for the information. We'll change the requirements for using TMSChangeNotification in our documentation.