SQL Server Data Access Components (SDAC) - VCL - V4.50 - Récapitulatif
par Devart (formerly Core Lab) - Type de produit : Composant / DLL / VCL
Récapitulatif
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
Autres liens
