Screenshot Preview

SQL Server Data Access Components (SDAC)

by Devart - Product Type: Component / DLL / VCL

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 supports SAL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7 and MSDE.

From
$ 143.95

Our regular prices are shown below. Please logon to see your discounted prices.

Showing: All Prices | Renewals Only  in

SQL Server Data Access Components (SDAC) Standard V6.8.16

Add to Cart $ 143.95 1 Developer License - with 1 Year Subscription Delivered via Download
Add to Cart $ 335.95 4 Developer Team License - with 1 Year Subscription Delivered via Download
Add to Cart $ 623.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download

SQL Server Data Access Components (SDAC) Professional V6.8.16

Add to Cart $ 195.95 1 Developer License - with 1 Year Subscription Delivered via Download
Add to Cart $ 48.95 1 Developer License - Upgrade from Standard V4x Delivered via Download
Add to Cart $ 48.95 1 Developer License - Upgrade from Standard V3x Delivered via Download
Add to Cart $ 489.95 4 Developer Team License - with 1 Year Subscription Delivered via Download
Add to Cart $ 146.95 4 Developer Team License - Upgrade from Standard V4x Delivered via Download
Add to Cart $ 117.55 4 Developer Team License - Upgrade from Standard V3x Delivered via Download
Add to Cart $ 881.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download
Add to Cart $ 244.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V4x Delivered via Download
Add to Cart $ 215.55 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V3x Delivered via Download

SQL Server Data Access Components (SDAC) Professional V6.8.16 (Includes Source Code)

Add to Cart $ 335.95 1 Developer License - with 1 Year Subscription Delivered via Download
Add to Cart $ 88.15 1 Developer License - Upgrade from Professional V3x Delivered via Download
Add to Cart $ 832.95 4 Developer Team License - with 1 Year Subscription Delivered via Download
Add to Cart $ 215.55 4 Developer Team License - Upgrade from Professional V3x Delivered via Download
Add to Cart $ 1,469.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download
Add to Cart $ 391.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Professional V3x Delivered via Download

SQL Server Data Access Components (SDAC) Standard Subscription Renewals

Add to Cart $ 48.95 1 Developer License Subscription Renewal Delivered via Download
Add to Cart $ 117.55 4 Developer Team License Subscription Renewal Delivered via Download
Add to Cart $ 215.55 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Download

SQL Server Data Access Components (SDAC) Professional Subscription Renewals

Add to Cart $ 68.55 1 Developer License Subscription Renewal Delivered via Download
Add to Cart $ 166.55 4 Developer Team License Subscription Renewal Delivered via Download
Add to Cart $ 293.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Download

SQL Server Data Access Components (SDAC) Professional with Source Code Subscription Renewals

Add to Cart $ 117.55 1 Developer License Subscription Renewal Delivered via Download
Add to Cart $ 235.15 4 Developer Team License Subscription Renewal Delivered via Download
Add to Cart $ 489.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Download

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's new in SQL Server Data Access Components (SDAC) V6.8.16?

  • RAD Studio XE5 support.
  • Lazarus 1.0.12 support.
  • Ping method for Connection component.

What's new in SQL Server Data Access Components (SDAC) V6.6.11?

  • C++Builder 64-bit support.
  • Property added to specify connection port number.
  • NEXTGEN support improvements.
  • Support for ftGraphic and ftFmtMemo parameter data types.
  • Rad Studio XE3 support.
  • Windows 8 support.

What's new in SQL Server Data Access Components (SDAC) V6.0.1?

  • Embarcadero RAD Studio XE2 now supported
  • Application development for 64-bit Windows now supported
  • FireMonkey application development platform now supported
  • Support of master/detail relationship for TVirtualTable added
  • OnProgress event in TVirtualTable added
  • TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
  • Bug with excess memory allotment on recordset opening for SQL Server Compact Edition is fixed

What's new in SQL Server Data Access Components (SDAC) V5.10?

  • Lazarus 0.9.30 and Free Pascal 2.4.2 support
  • Support for Table-Valued Parameters has been added
  • A TMSTableData component for storing data of Table-Valued Parameter type has been added
  • Support for an API interface for managing FILESTREAM data has been added
  • Support for SQL Server Compact Edition 4.0 has been added
  • Bug in bookmark validity check has been fixed
  • Bug with processing varchar(max) output parameters in stored procedure has been fixed
  • Bug with using empty string in the Filter property has been fixed

What's new in SQL Server Data Access Components (SDAC) V5.00?

  • Embarcadero RAD Studio XE supported

What's new in SQL Server Data Access Components (SDAC) V4.80?

  • Embarcadero RAD Studio 2010 supported
  • Added the TCustomMSDataSet.HasNextResultSet method to check if the next recordset is available
  • Now the subdetail is refreshed before the AfterRefresh event of the detail is called
  • Fixed bug with processing DateTime fields on table locking

What's new in SQL Server Data Access Components (SDAC) V4.70?

  • Delphi 2009 and C++Builder 2009 supported
  • Extended Unicode support for Delphi 2007 added (special Unicode build)
  • Free Pascal 2.2 supported
  • Powerful design-time editors implemented in Lazarus
  • Completed with more comprehensive structured Help

What's new in SQL Server Data Access Components (SDAC) V4.?

  • 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

SQL Server Data Access Components V4.0 Improvements

  • SQL Server Compact Edition supported
  • Multiple Active Result Sets (MARS) and other new SQL 2005 features supported
  • Added new TMSLoader, TMSDump, TCRBatchMove, TMSScript and TMSServiceBroker components
  • Added asynchronous execute and fetch modes
  • Compressed BLOBs support

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.

Standard

  • Base Components (TMSConnection, TMSQuery, TMSSQL, TMSTable, TMSStoredProc, TMSUpdateSQL, TMSSQLMonitor, TMSConnectDialog, TMSScript, TMSDataSource, TCRDBGrid, TVirtualTable, MSDataAdapter)
  • Design-time features, including component editors and property editors
  • DataSet Manager
  • Migration Wizard

Professional

  • Additional Components(TMSLoader, TMSDump, TMSServiceBroker, TMSMetadata, TCRBatchMove)
  • Base Components (TMSConnection, TMSQuery, TMSSQL, TMSTable, TMSStoredProc, TMSUpdateSQL, TMSSQLMonitor, TMSConnectDialog, TMSScript, TMSDataSource, TCRDBGrid, TVirtualTable, MSDataAdapter)
  • Design-time features, including component editors and property editors
  • DataSet Manager
  • Migration Wizard

Following are the main features of SQL Server Data Access Components:

  • No distribution, installation and configuration is required for BDE and ODBC;
  • You can use any Delphi Professional Edition to develop client/server applications;
  • VCL and VCL.NET versions of library
  • Supports MS SQL Server specific features: windows authentication, metadata, unicode fields, manual refresh for record in a dataset, automatic getting Identity value and results of triggers work and a lot of more;
  • Simplifies data updating;
  • Speeds up fetch of records from database;
  • Provides automatic refresh for records;
  • Advanced design time editors;
  • Interface (methods, properties) of SDAC components is similar to those of standard BDE data access components (TDatabase, TQuery, ..);
  • Extended SQL tracing capabilities provided by TMSSQLMonitor component and DBMonitor application;
  • Includes source code of TCRDBGrid enhanced data-aware grid control;
  • Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport;
  • and many other features.

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Award