SQL Server Data Access Components (SDAC) - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQL Server Data Access Components (SDAC) by Devart

URLs: core-lab-sql-server-data-access-components-sdac, core lab sql server data access components sdac, corelabsqlserverdataaccesscomponentssdac, devart

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.

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.

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

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

Pricing: SQL Server Data Access Components (SDAC) Standard V6.6.11 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Standard V6.6.11 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Standard V6.6.11 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Developer License - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Developer License - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.6.11 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 4 Developer Team License - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.6.11 4 Developer Team License - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.6.11 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 1 Developer License - Upgrade from Professional V3x, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 4 Developer Team License - Upgrade from Professional V3x, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.6.11 (Includes Source Code) 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Professional V3x, SQL Server Data Access Components (SDAC) Standard Subscription Renewals 1 Developer License Subscription Renewal, SQL Server Data Access Components (SDAC) Standard Subscription Renewals 4 Developer Team License Subscription Renewal, SQL Server Data Access Components (SDAC) Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, SQL Server Data Access Components (SDAC) Professional Subscription Renewals 1 Developer License Subscription Renewal, SQL Server Data Access Components (SDAC) Professional Subscription Renewals 4 Developer Team License Subscription Renewal, SQL Server Data Access Components (SDAC) Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, SQL Server Data Access Components (SDAC) Professional with Source Code Subscription Renewals 1 Developer License Subscription Renewal, SQL Server Data Access Components (SDAC) Professional with Source Code Subscription Renewals 4 Developer Team License Subscription Renewal, SQL Server Data Access Components (SDAC) Professional with Source Code Subscription Renewals 1 Site Wide License (Allows Unlimited Developers

Evals & Downloads: Read the SQL Server Data Access Components (SDAC) help file, Read the SQL Server Data Access Components (SDAC) End User License Agreement, Download the SQL Server Data Access Components (SDAC) V6.6.11 evaluation on to your computer - Expires after 60 days

Operating System for Deployment: Windows 8, Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: DLL, VCL

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, Embarcadero RAD Studio XE3, Embarcadero RAD Studio XE2, Embarcadero RAD Studio XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009, C++Builder XE3, C++Builder XE2, C++Builder XE, C++Builder 2010, C++Builder 2009, C++Builder 2007, C++Builder 2006, C++Builder 6, C++Builder 5, Delphi XE3, Delphi XE2, Delphi XE, Delphi 2010, Delphi 2009, Delphi 2007 for Win32, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, Delphi 6.0, Delphi 5.0, FireMonkey

Keywords: devart, dev, art, sdac, component

crlab corelab

SQL query language

Part numbers: PC-517208-507766 517208-507766 PC-517208-507768 517208-507768 PC-517208-507770 517208-507770 PC-517208-507774 517208-507774 PC-517208-507780 517208-507780 PC-517208-507790 517208-507790 PC-517208-507776 517208-507776 PC-517208-507786 517208-507786 PC-517208-507792 517208-507792 PC-517208-507778 517208-507778 PC-517208-507788 517208-507788 PC-517208-507794 517208-507794 PC-517208-507772 517208-507772 PC-517208-507796 517208-507796 PC-517208-507782 517208-507782 PC-517208-507798 517208-507798 PC-517208-507784 517208-507784 PC-517208-507800 517208-507800 PC-517208-507802 517208-507802 PC-517208-507804 517208-507804 PC-517208-507806 517208-507806 PC-517208-507808 517208-507808 PC-517208-507810 517208-507810 PC-517208-507812 517208-507812 PC-517208-507814 517208-507814 PC-517208-507816 517208-507816 PC-517208-507818 517208-507818