About SQL Server Data Access Components (SDAC)

Provide data access to SQL Server databases from your VCL applications.

SQL Server Data Access Components (SDAC) library offers a set of nonvisual components for Delphi and C++ Builder. They provide access to Microsoft SQL Server and are an alternative to the standard way of accessing databases using Borland Database Engine (BDE).

SDAC uses OLE DB directly through a set of COM-based interfaces that expose data from a variety of sources. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling the data store to share its data.

Using BDE in MS SQL Server oriented client/server applications has some deficiencies. In many cases BDE community are unable to employ server specific features, they must tolerate excessive usage of resources, reduced speed of processing data, restricted distribution of an application and its administration.

Using BDE in database applications amounts to the following data path between server and client:
[SQL Server] <-> [DBLibrary] <-> [SQL Links] <-> [BDE] <-> [Application]

SDAC works directly through OLE DB, which is a native MS SQL Server interface. Applications with SDAC components access server directly:
[SQL Server] <-> [OLE DB] <-> [Application]

SDAC includes following components:

  • TMSConnection - controls server connection;
  • TMSQuery - queries execution, operates record set, flexible way updating database tables;
  • TMSSQL - executes SQL statements;
  • TMSTable - allows to retrieve and update data single table without writing SQL statement;
  • TMSStoredProc - executes stored procedures and functions;
  • TMSSQLMonitor - allows to monitor dynamic SQL executing in SDAC based applications;
  • TMSConnectDialog - serves for enter username, password and server name;
  • TMSMetaData - allows to retrieve embracing metadata on specified SQL object;
  • TVirtualTable - dataset stores data in memory.

Only Professional, Enterprise and Architect editions are supported.

SQL Server Data Access Components comes in two editions: SDAC Standard Edition and SDAC Professional Edition.

SDAC Standard Edition includes the SDAC basic connectivity components and the SDAC Migration Wizard. SDAC Professional Edition includes additional components.

Professional

  • Direct Connectivity - Connection without SQL Server client
  • Desktop Application Development
    • Windows
    • macOS
    • Linux
  • Mobile Application Development
    • iOS
    • Android
  • Data Access Components
    • Base components
    • TMSConnection
    • TMSQuery
    • TMSSQL
    • TMSTable
    • TMSStoredProc
    • TMSUpdateSQL
    • TMSDataSource
  • Script executing
    • TMSScript
  • Transactions managing
    • TMSTransaction
  • Fast data loading into the server
    • TMSLoader
  • SQL Server Specific Components
    • Working with user-defined table types in SQL Server 2008 - TMSTableData
    • Connection to SQL Server Compact Edition - TMSCompactConnection
    • Reaction on server side changes on-the-fly - TMSChangeNotification
    • Sending messages with Service Broker system - TMSServiceBroker
    • Obtaining metainformation about database objects - TMSMetadata
    • Storing a database as a script - TMSDump
  • Database activity monitoring
    • Monitoring of per-component SQL execution - TMSSQLMonitor
  • Additional Components
    • Advanced connection dialog - TMSConnectDialog
    • Data encryption and decryption - TMSEncryptor
    • Data storing in memory table - TVirtualTable
    • Advanced DBGrid with extended functionality - TCRDBGrid
    • Records transferring between datasets - TCRBatchMove
  • Design-Time Features
    • Enhanced component and property editors
    • Migration Wizard
    • DataSet Manager

Standard

  • Desktop Application Development
    • Windows
  • Data Access Components
    • Base components
    • TMSConnection
    • TMSQuery
    • TMSSQL
    • TMSTable
    • TMSStoredProc
    • TMSUpdateSQL
    • TMSDataSource
  • Script executing
    • TMSScript
  • Transactions managing
    • TMSTransaction
  • SQL Server Specific Components
    • Working with user-defined table types in SQL Server 2008 - TMSTableData
  • Database activity monitoring
    • Monitoring of per-component SQL execution - TMSSQLMonitor
  • Additional Components
    • Advanced connection dialog - TMSConnectDialog
    • Data storing in memory table - TVirtualTable
    • Advanced DBGrid with extended functionality - TCRDBGrid
  • Design-Time Features
    • Enhanced component and property editors
    • Migration Wizard