SQL Server Data Access Components (SDAC) - VCL - V4.50 - Zusammenfassung

Überblick | Preise u. Lizenzierung | Evaluierungen u. Downloads | Kompatibilität | Herstellerinfo. | Rezensionen | Forum | Zusammenfassung

Zusammenfassung

SQL Server Data Access Components (SDAC) by Devart (formerly Core Lab)

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 Borland 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 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.

SDAC supports SQL Server 2005, SQL Server 2000, SQL Server 7 and MSDE. Following development environments are supported by SDAC:

Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++ Builder Personality

Borland Delphi 2005

Borland Delphi 8 with update pack 3

Borland Delphi 7

Borland Delphi 6 with update pack 2

Borland Delphi 5

Borland C++ Builder 6

Borland C++ Builder 5

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) 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

PartNumbers: PC-517208-137388 517208-137388 PC-517208-137389 517208-137389 PC-517208-137390 517208-137390 PC-517208-137392 517208-137392 PC-517208-137395 517208-137395 PC-517208-137400 517208-137400 PC-517208-137393 517208-137393 PC-517208-137398 517208-137398 PC-517208-137401 517208-137401 PC-517208-137394 517208-137394 PC-517208-137399 517208-137399 PC-517208-137402 517208-137402 PC-517208-137391 517208-137391 PC-517208-137403 517208-137403 PC-517208-137396 517208-137396 PC-517208-137404 517208-137404 PC-517208-137397 517208-137397 PC-517208-137405 517208-137405 PC-517208-137406 517208-137406 PC-517208-137407 517208-137407 PC-517208-137408 517208-137408 PC-517208-137409 517208-137409 PC-517208-137410 517208-137410 PC-517208-137411 517208-137411 PC-517208-137412 517208-137412 PC-517208-137413 517208-137413 PC-517208-137414 517208-137414

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

Resources: Read the SQL Server Data Access Components (SDAC) End User License Agreement, Download the SQL Server Data Access Components (SDAC) evaluation on to your computer - Expires after 60 days

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

Architecture of Product: 32Bit

Product Type: Component

Component Type: DLL, VCL

Compatible Containers: Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, C++Builder 6, C++Builder 5, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, Delphi 6.0, Delphi 5.0

Keywords: crlab corelab SQL query language Author