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 (formerly Core Lab)

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.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.0.1 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Standard V6.0.1 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Standard V6.0.1 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Developer License - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Developer License - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.0.1 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 4 Developer Team License - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.0.1 4 Developer Team License - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V4x, SQL Server Data Access Components (SDAC) Professional V6.0.1 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V3x, SQL Server Data Access Components (SDAC) Professional V6.0.1 (Includes Source Code) 1 Developer License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 (Includes Source Code) 1 Developer License - Upgrade from Professional V3x, SQL Server Data Access Components (SDAC) Professional V6.0.1 (Includes Source Code) 4 Developer Team License - with 1 Year Subscription, SQL Server Data Access Components (SDAC) Professional V6.0.1 (Includes Source Code) 4 Developer Team License - Upgrade from Professional V3x, SQL Server Data Access Components (SDAC) Professional V6.0.1 (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.0.1 (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 at a Single Physical Address) Subscription Renewal

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.0.1 evaluation on to your computer - Expires after 60 days

Operating System for Deployment: 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 XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009, C++Builder XE, C++Builder 2010, C++Builder 2009, C++Builder 2007, C++Builder 2006, C++Builder 6, C++Builder 5, 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

Keywords: devart, dev, art, sdac, component

crlab corelab

SQL query language

Part numbers: PC-517208-404627 517208-404627 PC-517208-404629 517208-404629 PC-517208-404631 517208-404631 PC-517208-404635 517208-404635 PC-517208-404641 517208-404641 PC-517208-404651 517208-404651 PC-517208-404637 517208-404637 PC-517208-404647 517208-404647 PC-517208-404653 517208-404653 PC-517208-404639 517208-404639 PC-517208-404649 517208-404649 PC-517208-404655 517208-404655 PC-517208-404633 517208-404633 PC-517208-404657 517208-404657 PC-517208-404643 517208-404643 PC-517208-404659 517208-404659 PC-517208-404645 517208-404645 PC-517208-404661 517208-404661 PC-517208-404663 517208-404663 PC-517208-404665 517208-404665 PC-517208-404667 517208-404667 PC-517208-404669 517208-404669 PC-517208-404671 517208-404671 PC-517208-404673 517208-404673 PC-517208-404675 517208-404675 PC-517208-404677 517208-404677 PC-517208-404679 517208-404679