SQL Server Data Access Components (SDAC) is a component library that provides local connections from Delphi and C++Builder to SQL Server, including Community Edition, as well as Lazarus (and Free Pascal) for Windows, Linux, macOS, iOS, and Windows. Suitable for Android on 32-bit and 64 bit platforms. SDAC based applications connect directly to SQL Server through OLE DB, which is a native SQL Server interface. SDAC aims to assist programmers in developing faster and cleaner SQL Server database applications.

SDAC is a high-performance and feature rich SQL Server connectivity solution that provides a complete replacement for standard SQL Server connectivity solutions. It offers an effective native alternative to Borland Database Engine (BDE) and standard dbExpress drivers for accessing SQL Server.

Local connection to SQL Server

SDAC based database applications are easy to deploy and do not require the installation of other data provider layers (such as BDE and ODBC), which is why they can be faster than applications based on standard Delphi data connectivity solutions. In addition, the features provided by SDAC can be used not only through OLE DB, but also through SQL Native Client in conjunction with SQL Server.

Cross platform development in Delphi, C++Builder, and Lazarus

SDAC is a cross platform solution for developing applications using SQL Server and various IDEs: RAD Studio, Lazarus (and FPC) platforms for x86 and x64 on Delphi, C++Builder, Windows, macOS, Linux, iOS, Android, and FreeBSD. SDAC also provides support for the FireMonkey application development platform, which allows you to develop visually striking high-performance desktop and mobile native applications.

Extensive coverage of SQL Server functionality

SDAC supports various SQL Server specific features such as transparent application failover, notifications, queuing, and reliable messaging, SQL Server Compact Edition， User defined types (including HierarchyID, Geography, Geometry), table valued parameters, Filestream, and others.

1. File Stream
2. Geography
3. SQL Server Lite
4. Queuing and reliable message delivery
5. Hierarchical ID
6. geometry
7. notice
8. User defined type
9. Table valued parameters
10. Transparent application failover
11. And more

Product Features

1. Direct mode

Allow your application to be used directly with SQL Server via TCP/IP without involving the SQL Server client, greatly simplifying application deployment and configuration.

1. Mobile development

Developing for iOS and Android mobile devices has become easier with SDAC, as it allows your mobile applications to use SQL Server databases just like desktop applications.

1. Database compatibility

SQL Server 2017、2016、2014、2012、2008 R2、 2008, 2005 (including Express version), SQL Server 2000 (including MSDE), SQL Server 7，SQL Server Compact 4.0、3.5、3.1，SQL Azure。

1. IDE compatibility

Our product is compatible with the latest IDE versions, including the Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with early IDE versions starting from Delphi 6 and C++Builder 6.

1. Data type mapping

If you want to customize the correspondence between SQL Server and Delphi data types, you can use the simple and flexible data type mapping engine provided by SDAC.

1. Development Platform

Support all major GUI frameworks: Develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.

1. performance

All of our components and libraries are designed to help you write high-performance, lightweight data access layers, utilizing advanced data access algorithms and optimization techniques.

1. Monitoring method

Use our free software dbMonitor tool to monitor and analyze all database calls made by your application using SQL Server data access components. DbMonitor tracks SQL statement execution, commit, rollback, and other operations by component.

1. support

Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.