SQL Server Data Access Components

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

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

Support for the latest Microsoft SQL Server versions, including Express and Compact editions
Support for all SQL Server data types
Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 12 Athens
Support for Lazarus 3.0 and Free Pascal 3.2.2
Includes provider for UniDAC Standard Edition
Support for reporting components, including InfoPower, ReportBuilder, and FastReport
Support for all standard Borland and third-party visual data-aware controls
Support for Professional Edition of Delphi and C++Builder for developing client/server applications

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

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

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

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

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