|
SQL Server Data Access Components (SDAC) V4.7
A Database API Control/Component
SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases. SDAC connects to SQL Server directly through OLE DB, which is a native SQL Server interface. The SDAC library is designed to help programmers develop faster and cleaner SQL Server database applications. SDAC is a complete replacement for standard SQL Server connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to SQL Server.
For more information go to
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.
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.
Using SQL Server Data Access gives you the following advantages:
- No distribution, installation and configuration is required for BDE and ODBC;
- You can use any Delphi Professional Edition to develop client/server applications;
- 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, ..)
- Supports all data-aware components;
- and many other features.
|
|
|
|
|
|
|
|
|
Product Type:
Control/Component
|
|
|
|
|
|
|
|
