Now I am in the position to upgrade to 5 because I need to use Delphi XE: can you comment on this? Are there some plans for v. 5.00 or shuold I consider v5 this the luxury tax to pay to use SDAC with XE?
5.00 new features:
4.00 new features:Embarcadero RAD Studio XE suppored
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