This page lists the functionality added in each version of SQL Server Data Access Components. To view the full changelog including bug fixes, consult the SDAC revision history.

09-Jan-08 New Features in SQL Server Data Access Components 4.35

• SQL Server Compact Edition 3.5 supported
• Tested with SQL Server 2008 CTP 4

27-Sep-07 New Features in SDAC 4.30

• CodeGear RAD Studio 2007 supported
• Added enhanced support for User-defined Types of SQL Server
• Added support for distributed transactions with the new TMSTransaction component
• Added support for Query Notifications with the new TMSChangeNotification component
• Improved support for SQL Server Compact Edition with the new TMSCompactConnection component
• Added support for getting results from queries with the FOR XML clause in readable view
• Added ability to lock records and tables
• TMSMetaData is enhanced with more schema row sets
• Added support for connection encryption without certificate validation
• Added ability to force record fetch for datasets open in FetchAll=False mode
• Added support for detailed error messages output to DBMonitor
• Added the OnProgress event in TMSLoader

15-Jun-07 New Features in SDAC 4.10

• C++Builder 2007 supported

22-Mar-07 New features in SDAC 4.00

• New functionality:
  • Delphi 2007 for Win32 supported
  • Disconnected model for working offline and automatically connecting and disconnecting supported
  • Local failover for detecting connection loss and implicitly reexecuting some operations supported
  • Added DataSet Manager to control project datasets
  • New TMSScript component for easy execution of multistatement scripts added:
    • Support for executing individual statements in scripts
    • Support for executing huge scripts stored in files with dynamic loading
    • Ability to use standard SQL Server client tool syntax
  • New component for transferring data between all types of TDataSets descendants added
  • New TMSServiceBroker component for SQL Server 2005 queuing and reliable messaging added
  • New TMSLoader component for improving records insertion performance added
  • New TMSDump component for loading data to and from the server added
  • Data export and import to/from XML supported
  • WideMemo field type in Delphi 2006 supported
  • Support for sending messages to DBMonitor from any point of your program added
  • Asynchronous fetch mode supported
  • Compressed BLOBs supported
• Support for more SQL Server functionality:
  • SQL Server Compact Edition supported
  • Multiple Active Result Sets (MARS) supported
  • Support for new data types, including XML, varchar(MAX), nvarchar(MAX), varbinary(MAX) added
  • Support for a new level of transaction isolation (DBPROPVAL_TI_SNAPSHOT) added
  • Support for more server objects in TMSMetaData added
  • Stored procedure parameters with default values supported
• Extensions and improvements to existing functionality:
  • General performance improved
  • Master/detail functionality extensions:
    • Local master/detail relationship support added
    • Master/detail relationship in CachedUpdates mode support added
  • Working with calculated and lookup fields improvements:
    • Local sorting and filtering added
    • Record location speed increased
    • Improved working with lookup fields
  • Greatly increased performance of applying updates in CachedUpdates mode
  • Connection pool functionality improvements:
    • Efficiency significantly improved
    • API for draining the connection pool added
  • Ability to customize update commands by attaching external components to TMSUpdateSQL objects added
  • Support for DefaultValues on record insertion added
  • Some performance improvements achieved:
    • NUMERIC fields fetching
    • Update commands execution while editing data set
    • DataSet refreshing
    • Records refreshing after updates and inserts
  • Support for selecting database name in TMSConnectDialog added
• Usability improvements:
  • Syntax highlighting in design-time editors added
  • Demo projects became better organized and clearer
  • FAQ added

28-Aug-06 New features in SDAC 3.80

• Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ supported

26-Jan-06 New features in SDAC 3.70

• Support for Delphi 2006 added
• Support for SQL Server 2005 added

30-May-05 New features in SDAC 3.55

• Improved behavior on editing master key on master/detail relation
• Optimized MSSQLMonitor BLOB parameters processing
• Ability of automatic preparing query with TCustomDADataSet.Options.AutoPrepare property added
• Ability to synchronize position at different DataSets with TCustomDADataSet.GotoCurrent method added

24-Jan-05 New features in SDAC 3.50

• Support for Delphi 2005 added
• Support for SQL Server 2005 beta 2 added
• Guid fields support for VirtualTable added

21-Oct-04 New features in SDAC 3.30

• Full support for all current authentication protocols added
• Generating update SQL for tables from other database added
• TCustomMyDataSet.Options.EnableBoolean property added
• TMyConnection.ThreadId property added
• lxPartialCompare option for DataSet.LocateEx added
• FastReport3 engine and demo added
• Ability to store only a part of data in TMyDump.BackupQuery added
• Creating additional connection for TMyDump disabled
• TCustomMyDataSet.CommandTimeout property added
• "True" value for boolean fields and parameters stored as "1"

27-Jul-04 New features in SDAC 3.00

• Support for Delphi 8 added
• Local sorting ability with TMemDataSet.IndexFieldNames added
• Connection pooling support
• TCRDBGrid sources in Standard edition
• MSDataAdapter component added
• .NET Windows Forms demo project added
• ASP.NET demo project added
• TMSConnection.GetStoredProcNames, GetTableNames, GetDatabaseNames added
• TMSConnection.ClientVersion, ServerVersion added
• Milliseconds support added

02-Oct-03 New features in SDAC 2.45.2

• Methods TMSSQL.BreakExec and TCustomMSDataSet.BreakExec added
• Property TMSConnection.Options.AutoTranslate added
• Method ExecSQL in TMSConnection added
• Methods GetTableNames and GetDatabaseNames in TMSConnection added
• Unicode support for Locate on Win9x added

04-Apr-03 New features in SDAC 2.45

• Property MSConnection.Options.WorkstationID added
• Performance to insert large BLOBs improved
• Performance significantly improved
• Event TMSConnection.OnInfoMessage added
• Multiple Errors support added
• Property MSConnection.Options.ApplicationName added
• Property TBlob.AsWideString added
• Parameters parsing improved. Symbol ':' in string literals is ignored
• Network error processing improved
• Performance demo added

24-Feb-03 New features in SDAC 2.40

• WideString support added
• Property MSDataSet.Options.QuoteNames added
• Property MSConnection.Options.KeepDesignConnected added
• Property MSConnectDialog.StoreLogInfo published

26-Dec-02 New features in SDAC 2.35

• Speed optimization for opening small queries
• MSConnection.Options added
• Limited MSConnection.ConnectString support added
• Output string and (var)bytes parameters are now obtained from the server with the maximum length not depending on set Param.Size
• DBMonitor client implementation moved to COM server

30-Sep-02 New features in SDAC 2.30

• Delphi 7 support
• New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on large tables fetch. Controlled by FlatBuffers dataset option
• Support for blob fields in CachedUpdates mode

09-Aug-02 New features in SDAC 2.05

• DBMonitor support

18-Jul-02 New features in SDAC 2.00

• Server cursors supported
• Queries with Multiple Result Sets supported
• Performance improved
• Opening queries without fetching all rows to client (FetchAll = False) supported
• UniDirectional support added
• Quick getting Identity value
• Refresh supported for StoredProc
• FullRefresh supported
• Check for old row values while executing Update and Delete added
• Changed behavior on close connection with open transaction from Commit to Rollback

21-Mar-02 New features in SDAC 1.30

• C++ Builder 6 supported

08-Nov-01 New features in SDAC 1.20

• Added TMSParam class to represent parameters
• Query Analyzer and Enterprise Manager integration added
• Accelerated getting identity value on refresh

26-Aug-01 First release of SDAC 1.00