Direct access to server data. Does not require installation of other data provider
layers (such as BDE and ODBC)
Interface compatible with standard data access methods, such as BDE and ADO
VCL, LCL and FMX versions of library available
Separated run-time and GUI specific parts allow you to create pure console applications
such as CGI
Unicode support
Network and connectivity
Disconnected Mode with automatic connection control for working with data offline
Local Failover for detecting connection loss and implicitly reexecuting certain
operations
Connection string support
Ability to search for installed SQL Server databases in a local network
Support for connection encryption without certificate validation
Compatibility
Full support of the latest Microsoft SQL Server versions, including Express and
Compact editions
Support for all SQL Server data types
Compatible with all IDE versions starting with Delphi 5 and C++Builder 5, except
Delphi 8, and with Free Pascal [New]
Includes provider for UniDAC Standard Edition [New]
Wide reporting component support, including support for InfoPower, ReportBuilder,
and FastReport
Wide support of all standard Borland and third-party visual data-aware controls
Allows you to use Professional Edition of Delphi and C++Builder to develop client/server
applications
SQL Server technology support
TMSLoader component for improving record insertion performance
TMSServiceBroker component for SQL Server 2005 queuing and reliable messaging
Enhanced support for User-defined Types of SQL Server
Enhanced support for SQL Server Compact Edition with the TMSCompactConnection
component
Possibility to change application name for a connection
Possibility to change workstation identifier for a connection
Configuration of OEM/ANSI character translation
Ability to lock records and tables
Performance
High overall performance
Fast controlled fetch of large data blocks
Optimized string data storing
Advanced connection pooling
High performance of applying updates in CachedUpdates mode
Caching of calculated and lookup fields
Fast Locate in a sorted DataSet
Preparing of user-defined update statements
Local data storage operations
Database-independent data storage with TVirtualTable component
CachedUpdates operation mode
Local sorting and filtering, including by calculated and lookup fields
Local master/detail relationship
Master/detail relationship in CachedUpdates mode
Data access and data management automation
Automatic data updating with TMSQuery, TMSTable and TMSStoredProc components
Support for Query Notifications with the TMSChangeNotification component
Automatic record refreshing
Automatic query preparing
Support for getting results from queries with the FOR XML clause in readable view
Support for ftWideMemo field type in Delphi 2006 and higher
Extended data access functionality
Separate component for executing SQL statements
Simplified access to table data with TMSTable component
Ability to retrieve metadata information with TMSMetadata component
BLOB compression support
Support for using macros in SQL
FmtBCD fields support
NonBlocking mode allows background executing and fetching data in separate threads
Ability to customize update commands by attaching external components to TMSUpdateSQL
objects.
Deferred detail DataSet refresh in master/detail relationships
MIDAS technology support
MSDataAdapter component for WinForms and ASP.NET applications.
Distributed transactions support with the TMSTransaction component
Data exchange
Transferring data between all types of TDataSet descendants with TCRBatchMove
component
Data export and import to/from XML (ADO format)
Ability to synchronize positions in different DataSets
Script execution
Advanced script execution features with TMSScript component
Support for executing individual statements in scripts
Support for executing huge scripts stored in files with dynamic loading
Optimized multi-statement script execution
SQL Execution monitoring
Extended SQL tracing capabilities provided by TMSSQLMonitor component and dbMonitor
Borland SQL Monitor support
Ability to send messages to dbMonitor from any point in your program
Visual extensions
Includes source code of enhanced TCRDBGrid data-aware grid control
Customizable connection dialog
Cursor changes during non-blocking execution
Design-time enhancements
DataSet Manager tool to control DataSet instances in the project
Advanced design-time component and property editors
Automatic design-time component linking
Easy migration from BDE and ADO with Migration Wizard
More convenient data source setup with the TMSDataSource component
Syntax highlighting in design-time editors
Product clarity
Complete documentation sets
A large amount of helpful demo projects
Error handling
Multiple error processing support
Unicode error messages support
Licensing and support
Included annual SDAC Subscription with Priority Support
Licensed royalty-free per developer, per team, or per site
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.