Base compatibility level and TMSChangeNotification

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Thu 20 Dec 2007 03:42

Base compatibility level and TMSChangeNotification

Post by ventura21 » Thu 20 Dec 2007 07:04

With the work of the component TMSChangeNotification into CodeGear Studio 2007 (MARS it is not used) with the base MS SQL 2005 (the level of compatibility 80) appears the message “The of connection of options of were of not of set of appropriately of when of the of command of was of submitted”. To establish the level of compatibility 90 for this base, for some reasons, would not like. Possibly whether simple to change any options for the initial base?

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 20 Dec 2007 15:14

This functionality is not intended to work in such compatibility level. You should consider switching to the standard compatibility level of SQL Server 2005 to use Change Notification.

Post Reply