SQL Server Data Access Components is an all-in-one library of components that offers seamless connectivity to SQL Server from Delphi and C++Builder, including the Community Edition, along with Lazarus (and Free Pascal) for various operating systems, including Windows, Linux, macOS, iOS, and Android.
SDAC lets you connect to SQL Server directly through OLE DB, a purely native interface for SQL Server. This feature enables programmers to build SQL Server database applications much faster and with a cleaner approach.
The recent release - SDAC - version 10.4.3. SQL Server Data Access Components (SDAC) has a lot of impressive features to boast about, such as support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12. With RAD Studio 11.1 Alexandria and Lazarus 2.2.0, SDAC provides support to all major IDEs, including the Delphi 6 up to the latest RAD Studio. SDAC is also compatible with Windows 11 and macOS Monterey.
SDAC prides itself on providing basic SQL Server connectivity components, high-performance DML batch updates, full support for SQL Server data types, timely customer support, and on-demand night builds with fixes. This connectivity also extends to direct SQL Server connectivity to enable mobile app development.
It is a great choice for developers who want support for macOS and Linux development, high-performance fill databases through TMSLoader, extended support for SQL Server-specific functionality, advanced dataset management features, and access to source code.
You can always find the latest version of the SDAC on the Devart website.
Version 11.4.0:
*Added support for RAD Studio 12 Athens Release 3
*Added support for the RAD Studio 64-bit IDE
*Added support for Lazarus 3.8
*Added support for parameters in the Script component
*Added the Charset connection option for the Direct mode
Version 11.3.0:
*Added support for RAD Studio 12 Athens Release 2
*Added support for C++Builder 64-bit Windows (Modern) Application Development
*Added support for Lazarus 3.4
*Added support for Variant OUT parameters in Direct mode
*Added C++Builder demo components for working with SecureBridge
Version 11.2.1: *Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
Version 11.1.0: *Lazarus 3.0 is supported
Version 11.0.0:
*Added support for RAD Studio 12
*Added support for SQL Server 2022
*Added support for macOS Sonoma
*Added support for iOS 17
*Added support for Android 13
*Added AddDateTimeFormat option for the Dump component
*Added support for nested Macros in SQL queries
Version 10.3.0:
*Added support for RAD Studio 11 Alexandria Release 3
*Added support for iOS Simulator target platform
*Added support for Lazarus 2.2.6
*Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
Version 10.2.0:
*Added support for RAD Studio 11 Alexandria Release 2
*Added support for Lazarus 2.2.2
*Added support for iOS 15
*Added support for Android 12
*Added support for Microsoft OLE DB Driver for SQL Server 9
*Added support for Azure AD authentication support for the Microsoft OLE DB provider