SDAC

Overview

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

The SDAC library is actively developed and supported by the Devart Team. If you have questions about SDAC, email the developers at sdac@devart.com or visit SDAC online at https://www.devart.com/sdac/.

Advantages of SDAC Technology

SDAC is a direct database connectivity wrapper built specifically for the SQL Server. SDAC offers wide coverage of the SQL Server feature set, and emphasizes optimized data access strategies.

Wide Coverage of SQL Server Features

By providing access to the most advanced database functionality, SDAC allows developers to harness the full capabilities of the SQL Server and optimize their database applications. SDAC provides complete support for working with SQL Server Compact Edition, SQL Server queuing and reliable messaging, IRowsetFastLoad interface, working with metadata information, MARS. Get a full list of supported SQL Server features in the Features topic.

Optimized Code

The goal of SDAC is to enable developers to write efficient and flexible database applications. The SDAC library is implemented using optimized code and advanced data access algorithms. Component interfaces undergo comprehensive performance tests and are designed to help you write efficient product data access layers. Find out more about using SDAC to optimize your database applications in Increasing Performance.

Compatibility with other Connectivity Methods

The SDAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to SDAC and enhanced to take advantage of SQL Server-specific features. Project migration can be automated with the BDE/ADO Migration Wizard. Find out more about Migration Wizard in Using Migration Wizard.

Development and Support

SDAC is an SQL Server connectivity solution that is actively developed and supported. SDAC comes with full documentation, demo projects, and fast (usually within one business day) technical support by the SDAC development team. Find out more about getting help or submitting feedback and suggestions to the SDAC Development Team in the Getting Support topic.

A description of the SDAC components is provided in the Component List.

Key Features

The full list of SDAC features are available in the Features topic.

How does SDAC work?

SDAC uses OLE DB directly through a set of COM-based interfaces to connect to server. SDAC is designed to be lightweight and consists of a minimal layer between your code and SQL Server databases.

In comparison, the Borland Database Engine (BDE) uses several layers to access SQL Server, and requires additional data access software to be installed on client machines.

The BDE data transfer protocol is shown below.

BDEFlow

BDE Connection Protocol

SDAC works directly through OLE DB, which is a native SQL Server interface. Applications with SDAC components access server directly:

OLEDBFlow

SDAC Connection Flow

© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback