Provides direct high performance access to SQL Server database

dbExpress driver for SQL Server

dbExpress driver for SQL Server

  -  14.3 MB  -  Trial
  • Latest Version

    dbExpress driver for SQL Server 9.3.1 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows XP / Vista / Windows 7 / Windows 8 / Windows 10

  • User Rating

    Click to vote
  • Author / Product

    Devart / External Link

  • Filename

    dbxsda.exe

dbExpress driver for SQL Server is a database-independent layer that defines common interface to provide fast access to SQL Server from Delphi and C++Builder including Community Edition on Windows and macOS for both 32-bit and 64-bit platforms. For this server, dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures. As the data-access layer is thin and simple, dbExpress provides high performance database connectivity and is easy to deploy. You can use the driver in the same way as the one supplied by Embarcadero.

Native Connectivity to SQL Server
Applications based on the app for SQL Server are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), and that's why they can work faster than the ones based on standard Delphi data connectivity solutions. Moreover, dbExpress Driver for SQL Server provides working with SQL Server not only through OLE DB but through SQL Native Client as well.

Developing in Delphi and C++Builder
This tool for SQL Server is a cross-IDE solution for developing applications for Windows and macOS: RAD Studio, Delphi, and C++Builder for both x86 and x64 platforms. dbExpress driver for SQL Server also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance native applications for Windows and macOS.

Features and Highlights

Performance
All these components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.

Database Compatibility
SQL Server 2017\2016\2014\2012\2008 R2\2008\2005 (including Express edition), SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0\3.5\3.1, SQL Azure.

64-bit Development
The app for SQL Server doesn't limit your choice of the development platform. Now you can develop for 32-bit and 64-bit platforms with Delphi.

dbMonitor
Use the freeware dbMonitor tool to monitor and analyze all the DB calls made by your application using dbExpressDriver for SQL Server. dbMonitor performs per­component tracing of SQL statement execution, commits, rollbacks, etc.

IDE Compatibility
The product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio. It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.

IDE Compatibility
Now you can develop not only VCL-based applications in Delphi but also use the newest FireMonkey application development platform.

Note: 30 days trial version.

What's new in this version:

dbExpress driver for SQL Server 9.3.1
- Added support for RAD Studio 12 Athens Release 1
- Fixed bug with Microsoft Entra identity authentication (auADInteractive) in the MSOLEDBSQL19 provider
- Fixed bug with updating datetime fields by OLEDB providers


dbExpress driver for SQL Server 9.3.0
Added:
- support for RAD Studio 12
- support for SQL Server 2022
- support for macOS Sonoma
- support for Azure AD authentication for the Microsoft OLE DB provider
- support for Azure database connection when using the "Redirect" connection policy in the Direct mode

Fixed:
- GUID data reading bug
- bug with connecting to the default instance
- bug with "Wrong amount of parameters N in TableName" when the TableName contains spaces


dbExpress driver for SQL Server 9.2.1
- Added support for RAD Studio 11 Alexandria Release 3
- Improved compatibility with Linked Server in MSSMS

Fixed:
- bug with Unicode (UTF-8) in the Direct mode for Windows
- bug with connecting to default instance by prSQL(SQLOLEDB.1) provider
- bug with preparing a stored procedure in the Direct mode


dbExpress driver for SQL Server 9.2.0
Added:
- support for RAD Studio 11 Alexandria Release 2
- support for Microsoft OLE DB Driver for SQL Server 9
- passing the "client_interface_name" parameter to the server in the Direct mode

Fixed:
- bug with setting a DateTime value before the year 1753 to the parameter
- bug with the Access Violation failure when reading the Variant fields data
- bug with committing transaction on SQL Server 2000 in Direct mode


dbExpress driver for SQL Server 9.1.1
- MARS is supported
- Snapshot transaction support is added
- Always On availability groups for the Native Client and MSOLEDBSQL provider is supported


dbExpress driver for SQL Server 9.0.1
- RAD Studio 11 Alexandria is supported
- macOS ARM target platform is supported


dbExpress driver for SQL Server 8.3.2
- Fixed bug with converting memo fields to the local encoding


dbExpress driver for SQL Server 8.2.3
- Fixed bug with converting memo fields to the local encoding


dbExpress driver for SQL Server 8.2.1
- RAD Studio 10.4 Sydney is supported


dbExpress driver for SQL Server 8.1.4
- Bug with performing a TLS 1.2 handshake during connection attempt to the server in Direct mode is fixed


dbExpress driver for SQL Server 8.1.3
- TLS 1.2 support in the Direct mode is added
- Now Trial edition for macOS and Linux is fully functional
- Automatic creation of parameters for a command is supported
- Bug with getting the number of affected rows in Direct mode is fixed


dbExpress driver for SQL Server 8.0.2
- The CRHttp.pas file is no longer required for Edition with Source Code


dbExpress driver for SQL Server 8.0.1
- macOS 64-bit is supported
- Linux 64-bit is supported
- Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required


dbExpress driver for SQL Server 7.5.7
- RAD Studio 10.3 Rio is supported
- Windows authentication in the Direct mode is supported
- MARS in the Direct mode is supported


dbExpress driver for SQL Server 7.4.6
- RAD Studio 10.2 Tokyo is supported


dbExpress driver for SQL Server 7.3.5
- Support for IPv6 protocol in Direct Mode is added
- The NullForZeroDelphiDate option to hide the "30-12-1899" dates is added
- Bug with processing tinyint fields is fixed