What's new in dbExpress driver for SQL Server 9.3.1

May 9, 2024
  • 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

New in dbExpress driver for SQL Server 9.3.0 (Nov 15, 2023)

  • Added support for RAD Studio 12
  • Added support for SQL Server 2022
  • Added support for macOS Sonoma
  • Added support for Azure AD authentication for the Microsoft OLE DB provider
  • Added support for Azure database connection when using the "Redirect" connection policy in the Direct mode
  • Fixed GUID data reading bug
  • Fixed bug with connecting to the default instance
  • Fixed bug with "Wrong amount of parameters N in TableName" when the TableName contains spaces

New in dbExpress driver for SQL Server 9.2.1 (Mar 29, 2023)

  • 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
  • Fixed bug with connecting to default instance by prSQL(SQLOLEDB.1) provider
  • Fixed bug with preparing a stored procedure in the Direct mode

New in dbExpress driver for SQL Server 9.2.0 (Sep 27, 2022)

  • Added support for RAD Studio 11 Alexandria Release 2
  • Added support for Microsoft OLE DB Driver for SQL Server 9
  • Added 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
  • Fixed bug with the Access Violation failure when reading the Variant fields data
  • Fixed bug with committing transaction on SQL Server 2000 in Direct mode

New in dbExpress driver for SQL Server 9.1.1 (Dec 10, 2021)

  • MARS is supported
  • Snapshot transaction support is added
  • Always On availability groups for the Native Client and MSOLEDBSQL provider is supported

New in dbExpress driver for SQL Server 9.0.1 (Sep 16, 2021)

  • RAD Studio 11 Alexandria is supported
  • macOS ARM target platform is supported

New in dbExpress driver for SQL Server 8.3.2 (Jul 22, 2021)

  • Fixed bug with converting memo fields to the local encoding

New in dbExpress driver for SQL Server 8.2.3 (Jul 16, 2021)

  • Fixed bug with converting memo fields to the local encoding

New in dbExpress driver for SQL Server 8.2.1 (Jun 10, 2020)

  • RAD Studio 10.4 Sydney is supported

New in dbExpress driver for SQL Server 8.1.4 (Feb 28, 2020)

  • Bug with performing a TLS 1.2 handshake during connection attempt to the server in Direct mode is fixed

New in dbExpress driver for SQL Server 8.1.3 (Nov 28, 2019)

  • 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

New in dbExpress driver for SQL Server 8.0.2 (Aug 22, 2019)

  • The CRHttp.pas file is no longer required for Edition with Source Code.

New in dbExpress driver for SQL Server 8.0.1 (Aug 13, 2019)

  • 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

New in dbExpress driver for SQL Server 7.5.7 (Dec 12, 2018)

  • RAD Studio 10.3 Rio is supported
  • Windows authentication in the Direct mode is supported
  • MARS in the Direct mode is supported

New in dbExpress driver for SQL Server 7.4.6 (Apr 19, 2017)

  • RAD Studio 10.2 Tokyo is supported

New in dbExpress driver for SQL Server 7.3.5 (Nov 3, 2016)

  • 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

New in dbExpress driver for SQL Server 7.2.4 (Jun 23, 2016)

  • RAD Studio 10.1 Berlin is supported.
  • Bug with AV failure on opening dataset for MS SQL Server Compact Edition is fixed.

New in dbExpress driver for SQL Server 7.1.3 (Jun 23, 2016)

  • Bug with processing tinyint fields is fixed.
  • Bug with AV on calling TSQLDataSet.Close is fixed.

New in dbExpress driver for SQL Server 7.1.2 (Jun 23, 2016)

  • RAD Studio 10 Seattle is supported.
  • Now Trial for Win64 is a fully functional Standard Edition.
  • 'Catastrophic failure' on data fetching is fixed.

New in dbExpress driver for SQL Server 7.0.1 (Jun 23, 2016)

  • RAD Studio XE8 is supported.
  • Mac OS X is supported.
  • Direct mode is supported.
  • Bug with TWideMemoField data size is fixed.
  • Bug with processing real fields is fixed.
  • Bug with setting the TField.Required value when the RequiredFields option is set to 'Required' is fixed.

New in dbExpress driver for SQL Server 6.5.7 (Sep 23, 2014)

  • RAD Studio XE7 is supported
  • The BCDPrecision option to represent number fields as TBCDField or TFMTBCDField is added
  • Bug with processing tinyint, bigint, and real fields is fixed
  • Bug with processing varchar parameters in stored procedure is fixed

New in dbExpress driver for SQL Server 6.4.6 (Jun 2, 2014)

  • RAD Studio XE6 is supported
  • Bug with processing varchar parameters in stored procedure is fixed
  • Bug with processing tinyint and single parameters in SQL Server Compact Edition is fixed
  • Bug with hanging application on closing dataset with non-fetched records is fixed

New in dbExpress driver for SQL Server 6.3.5 (Jun 2, 2014)

  • RAD Studio XE5 Update 2 is now required
  • Bug with mapping to BCD fields when using TClientDataSet is fixed
  • Bug with processing varbinary(max) output parameters in stored procedure is fixed
  • Bug with getting stored procedure parameters is fixed
  • Bug with returning values of timestamp parameters is fixed

New in dbExpress driver for SQL Server 6.3.4 (Dec 23, 2013)

  • Rad Studio XE5 is supported
  • Now the length of TStringField fields created for sql_variant server type is 8000
  • Bug with processing parameters of stored procedures is fixed
  • Bug with "Multiple-Step OLE DB Operation generated errors" is fixed

New in dbExpress driver for SQL Server 6.2.3 (May 31, 2013)

  • Rad Studio XE4 is supported
  • Assembly registration without .NET SDK installed is improved
  • SchemaOverride connection parameter for dbExpress 4 metadata is added
  • ParamPrefix connection parameter that allows deleting the "@" symbol from parameters names of stored procedure for dbExpress 4 metadata is supported
  • SQL Azure support for dbExpress 4 metadata is improved
  • The 'Unexpected data type 25' error in Delphi 2007 is fixed
  • Bug with processing stored procedures for dbExpress 4 is fixed
  • Bug with not quoting server object names is fixed
  • Bug when opening table for SQL Server Compact Edition 4.0 for 64-bit Windows is fixed
  • C++Builder 64-bit for Windows is supported
  • The 'Unknown Data Type' error when using parameters is fixed
  • Bug with getting stored procedure parameters is fixed
  • Bug with retrieving no result parameters is fixed
  • Windows 8 is supported
  • Data Explorer is supported
  • dbExpress 4 metadata is supported
  • SQL Server Native Client 11 (SQL Server 2012) support is added
  • Bug with setting an empty value to FmtBCD parameters for SQL Server 2000 is fixed
  • Bug with getting system stored procedure params in Delphi 2007 and higher is fixed

New in dbExpress driver for SQL Server 5.0.3 (Apr 6, 2012)

  • NativeClient 2008 support is improved
  • Bug with detecting parameters of stored procedure is fixed
  • Bug with the stored procedures executing in SQL Azure is fixed
  • Bug with processing smallmoney data type parameters for MS SQL Server 2000 is fixed

New in dbExpress driver for SQL Server 5.0.2 (Dec 29, 2011)

  • Several bugs with SQL Azure are fixed
  • Now raised exception contains SQL error code together with error message
  • Fixed bug with setting Unicode symbols to parameters values for stored procedures

New in dbExpress driver for SQL Server 5.0.1 (Nov 9, 2011)

  • Embarcadero RAD Studio XE2 is supported
  • Application development for 64-bit Windows is supported
  • FireMonkey application development platform is supported
  • dclcrdbxXXX.dcp is added to installation
  • Bug with excess memory allotment on recordset opening for SQL Server Compact Edition is fixed
  • Bug with processing DATETIME2 parameters in stored procedure for SQL Server 2008 is fixed

New in dbExpress driver for SQL Server 4.80.29 (Nov 9, 2011)

  • Support for SQL Server Compact Edition 4.0 is added
  • Bug with processing varchar(max) parameters in stored procedure is fixed

New in dbExpress driver for SQL Server 4.75.28 (Nov 9, 2011)

  • Now the DBXERR_INVALIDUSRPASS error code is returned on connection establishing with invalid user name or password
  • Fixed several bugs with installation of dbExpress driver on different IDEs
  • Fixed bug with calculating length of XML fields

New in dbExpress driver for SQL Server 4.75.27 (Nov 9, 2011)

  • Fixed bug with rollback transaction after failed commit
  • Fixed bug with processing int64 parameters
  • Fixed bug with processing parameters when query is executed with error
  • Fixed bug with processing varchar(max) parameters in stored procedure
  • Fixed bug with processing time parameters for SQL Server 2005
  • Fixed bug with AV failure when non-string value is set to string parameter
  • Fixed bug with processing large GEOMETRY and GEOGRAPHY fields

New in dbExpress driver for SQL Server 4.75.26 (Nov 9, 2011)

  • Embarcadero RAD Studio XE supported
  • Improved performance of working with UDT fields
  • Fixed bug with processing large GEOMETRY and GEOGRAPHY fields

New in dbExpress driver for SQL Server 4.55.23 (Nov 9, 2011)

  • Fixed bug with processing DATE and TIME field types for SQL Server 2008
  • Fixed bug with cascade deleting records for SQL Server Compact Edition
  • Fixed bug with AV failure on connection closing under CLR

New in dbExpress driver for SQL Server 4.55.22 (Nov 9, 2011)

  • Fixed bug with processing LargeInt fields and parameters
  • Fixed bug with processing DECIMAL fields when EnableBCD = False
  • Fixed bug with processing TIME fields for SQL Server 2008
  • Fixed bug with processing Widememo fields for SQL Server Compact Edition

New in dbExpress driver for SQL Server 4.55.21 (Nov 9, 2011)

  • Added support for dbMonitor 3
  • Added support of DATETIMEOFFSET field type for SQL Server 2008

New in dbExpress driver for SQL Server 4.55.20 (Nov 9, 2011)

  • Fixed bug with fetching BLOB data for Delphi 2010
  • Fixed bug with mapping decimal fields to float fields for stored procedure parameters when EnableBCD=False

New in dbExpress driver for SQL Server 4.55.19 (Sep 30, 2009)

  • Embarcadero RAD Studio 2010 suppored
  • Fixed several bugs related to using the driver with Datasnap componets

New in dbExpress driver for SQL Server 4.45.18 (Sep 30, 2009)

  • Fixed bug with inserting space in FixedChar fields
  • Fixed bug with getting field aliases for SQL Server Compact Edition
  • Fixed bug with calculating count of using the sqlncli library

New in dbExpress driver for SQL Server 4.45.16 (Sep 30, 2009)

  • Fixed bug with processing NTEXT fields for Delphi 2009
  • Fixed exception on disconnect caused by DBMonitor check

New in dbExpress driver for SQL Server 4.45.15 (Sep 30, 2009)

  • Added connection loss processing
  • Fixed bug with processing stored procedures when not default schema name is used

New in dbExpress driver for SQL Server 4.45.14 (Sep 30, 2009)

  • Added driver compiled with Delphi 2007 for using under Windows 98
  • Fixed bug for Delphi 2009 with editing varchar fields which contain Unicode symbols
  • Fixed bug with processing date/time fields in prepared stored procedures for SQL Server 2008
  • Fixed bug with incorrect unit name used in Driver Properties

New in dbExpress driver for SQL Server 4.45.0.13 (Dec 18, 2008)

  • Added support of DATE and TIME field types for SQL Server 2008
  • Fixed bug with specifying provider version for MS SQL Server Compact Edition
  • Fixed bug with processing parameter of XML type of StoredProcedure

New in dbExpress driver for SQL Server 4.45.0.12 (Oct 20, 2008)

  • Support for Delphi 2009 and C++Builder 2009 added
  • Added full Unicode support for RAD Studio 2009

New in dbExpress driver for SQL Server 4.20.0.5 (Nov 14, 2007)

  • Complete support for dbExpress version 4 in Delphi 2007 for Win32 and C Builder 2007 added
  • Added support for SQL Server Compact Edition and new SQL Server data types
  • CodeGear RAD Studio 2007 supported
  • UseUnicodeMemo added option to ensure backward compatibility for Unicode mode

New in dbExpress driver for SQL Server 3.20.10 (Jun 19, 2007)

  • Added limited Delphi 2007 support for Win32