SQL Server Data Access Components (ID #25760)

Devart

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

Compatibility
-------------

SDAC supports SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7, MSDE and Compact Edition. Following development environments are supported by SDAC:
CodeGear Delphi 2009 for Win32
CodeGear C++Builder 2009
CodeGear Delphi 2007 for Win32
CodeGear C++Builder 2007
Turbo Delphi Professional
Turbo Delphi for .NET Professional
Turbo C++ Professional
Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++Builder Personality
Borland Delphi 2005
Borland Delphi 8
Borland Delphi 7
Borland Delphi 6
Borland Delphi 5
Borland C++Builder 6
Borland C++Builder 5
Only Professional, Enterprise and Architect editions are supported.

SQL Server Data Access Components home page