dbExpress Driver for SQL Server History

9.3.0 15-Nov-23

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

9.2.1 29-Mar-23

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

9.2.0 26-Sep-22

Added support for RAD Studio 11 Alexandria Release 2
Added support for Microsoft OLE DB Driver for SQL Server 19
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

9.1.1 10-Dec-21

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

9.0.1 16-Sep-21

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

8.3.2 14-Jul-21

Fixed bug with converting memo fields to the local encoding

8.3.1 27-Aug-20

SQL Server 2019 is supported
Failure to connect with different credentials after unsuccessful initial connection attempt is fixed
Bug with data type mapping for [money NOT NULL] is fixed
Bug with mapping of decimal and numeric data types is fixed
Bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server is fixed

8.2.1 09-Jun-20

RAD Studio 10.4 Sydney is supported

8.1.4 28-Feb-20

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

8.1.3 28-Nov-19

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

8.0.2 22-Aug-19

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

8.0.1 12-Aug-19

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
Support for Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is added
Quoted database names when executing a stored procedure are supported

7.5.7 12-Dec-18

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

7.4.6 18-Apr-17

RAD Studio 10.2 Tokyo is supported

7.3.5 26-Oct-16

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

7.2.4 28-Apr-16

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

7.1.3 17-Feb-16

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

7.1.2 10-Sep-15

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

7.0.1 17-Apr-15

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

6.5.7 19-Sep-14

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

6.4.6 28-May-14

RAD Studio XE6 is supported
SQL Server 2014 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

6.3.5 21-Feb-14

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

6.3.4 21-Oct-13

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

6.2.3 17-May-13

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

6.1.2 25-Dec-12

Rad Studio XE3 Update 1 is now required
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

6.0.1 10-Sep-12

Rad Studio XE3 is supported
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

5.0.3 20-Mar-12

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

5.0.2 16-Dec-11

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

5.0.1 15-Sep-11

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

4.80.29 16-May-11

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

4.75.28 03-Mar-11

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

4.75.27 07-Dec-10

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

4.75.26 06-Oct-10

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

4.55.23 02-Jul-10

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

4.55.22 25-Mar-10

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

4.55.21 07-Dec-09

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

4.55.20 09-Oct-09

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

4.55.19 23-Sep-09

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

4.45.18 04-Sep-09

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

4.45.16 10-Jun-09

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

4.45.15 27-Mar-09

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

4.45.14 20-Jan-09

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

4.45.13 26-Nov-08

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

4.45.12 16-Oct-08

Added full Unicode support for RAD Studio 2009

4.45.11 04-Sep-08

Support for Delphi 2009 and C++Builder 2009 added

4.25.10 22-Aug-08

Added support of MS SQL Server 2008 Native Client
Added feature to set the 'max database size' option for MS SQL Server Compact Edition
Fixed bug with multiple connections to databases of SQL Server Compact Edition 3.1
Fixed bug with mapping decimal fields to float fields when EnableBCD=False
Fixed bug with returning empty strings as output parameters from stored procedures
Fixed Assert when a query with parameters is opened several times

4.25.9 19-Jun-08

Fixed bug with updating UNIQUEIDENTIFIER fields under BDS 2006 and higher

4.25.8 07-Mar-08

Bug with infinite reconnect fixed
Fixed access violation with multiple database connections from an application
Fixed bug with truncation of fractional part of BCD values in dbExpress 4

4.25.7 05-Feb-08

Added support for SQL Server Compact Edition 3.5
Tested with SQL Server 2008 CTP 4
Added ability for setting client provider through the VendorLib property
Fixed some bugs with getting metainformation from SQL Server Compact Edition

4.20.6 12-Dec-07

Added the DbxSdaDriverLoader unit in DbxSda Source Code edition to enable embedding the driver into applications
Added support for opening TSQLDataSet with DbxCommandType = DbxMetaData
Memory leak in the driver fixed
Fixed bug with truncation of MEMO values that contain #0 symbols

4.20.5 29-Oct-07

Several bugs in installation fixed
Fixed bug with an arithmetic overflow for BIGINT fields of SQL Server 2000

4.20.4 10-Oct-07

CodeGear RAD Studio 2007 supported

4.10.3 28-Aug-07

Failover Partner and Multiple Active Result Sets features of SQL Server 2005 supported
Added the UseUnicodeMemo option to ensure backward compatibility for Unicode mode
Fixed bug with XML data type
Fixed bug with retrieving metadata in Delphi 2007

4.00.2 12-Jul-07

Complete support for dbExpress version 4 in Delphi 2007 for Win32 and C++Builder 2007 added
Added support for SQL Server Compact Edition
Support for new SQL Server data types, including XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) added
General performance improved

3.20.10 04-May-07

Added limited support for Delphi 2007 for Win32
Fixed bug with describing parameters of system stored procedures in SQL Server 2005
Fixed bug with NUMERIC fields with precision of 32 or higher
Fixed bug with DateTime parameters in TSQLStoredProc

3.10.8 06-Dec-06

Fixed out of memory bug on huge tables with BLOB fields
Removed workaround for dbExpress bug with Memo field value truncation (this bug is fixed in BDS 2006 Update 2)

3.10.7 31-Oct-06

Limited support added for Windows Vista Beta 2

3.10.6 04-Sep-06

Added support for Turbo Delphi, Turbo Delphi for .NET and Turbo C++
Additional option RequiredFields for TSQLConnection available

3.00.5 07-Jul-06

Fixed bug with connecting to SQL Server 2005 via TCP/IP protocol

3.00.4 14-Apr-06

Fixed bug with getting SQL Server 2005 metadata

3.00.3 28-Feb-06

Fixed bug with describing SQL Server 2005 stored procedures
Fixed bug with fetching (N)VARCHAR(4000) fields

3.00.2 07-Feb-06

Additional option CommandTimeout for TSQLConnection available

3.00.1 03-Feb-06

Delphi 2006 supported
Delphi 2005 NormalizeBCD bug avoided
Unicode support with coUseUnicode added (Delphi 2006)
Fixed bug with fetching decimal fields

2.50.7 12-Oct-05

Fixed bug with Int64 parameters in stored procedures

2.50.6 04-Aug-05

Fixed bug with date and time params in StoredProcs
Fixed bug with exception type, raised on transaction operation fail

2.50.5 29-Mar-05

Fixed bug with posting FmtBcd values

2.50.4 27-Jan-05

Support for Delphi 2005 added
Support for SQL Server 2005 Beta 2 added
Performance improved for executing prepared SP returning cursor
Fixed bug with #0 in Memo parameters

2.00.3 15-Nov-04

Fixed bug with getting indicies in SQL Server 7
Fixed bug with updating bigint fields (5089)

2.00.1 20-Aug-04

Delphi8 support added
Support 'Custom string' parameter added (Delphi 7 only)
SQLStoredProc.NextRecordSet support added
Additional option coParamPrefix for TSQLConnection available
SQLConnection.Params['OS Authentication'] support added
ftDate, ftTime parameters supported
New time trial limitation
Fixed bug with DECIMAL with low precision
Fixed bug with small memory leak on SQL error (4344)
Fixed bug with Nullable fields on Delphi8 (4163)
Fixed bug in SQLMonitor with Date and Time parameters

1.86 07-Oct-03

SQLConnection.Params['TRIM CHAR'] support added
Getting MetaData.getProcedures improved
Fixed bug with describing parameters from StoredProc (3335)

1.85 21-Aug-03

Fixed bug with TCRConnection for CBuilder
Fixed rare bug with describing parameters from StoredProc (3248)
Fixed bug with type-mapping of NUMERIC (10, 0) (3223)

1.84 12-Jun-03

Fixed bug with getting result from StoredProc what uses temp tables (2969)
Additional option TrimFixedChar to TSQLConnection available

1.83 26-Mar-03

Performance improved
Additional option Prepared for TSQLConnection available
Fixed bug with storing large decimal values
Fixed bug with displaying BCD parameters in SQLMonitor

1.82 26-Feb-03

Fixed bug with some memory leak on each connection to server (SDAC-2679)
Fixed bug in processing decimals with large precision (SELECT @@Identity)

1.81 26-Dec-02

DBMonitor client implementation moved to COM server
Fixed bug with generating string params value (Null) for SQLMonitor (2511)
Fixed bug with output param size processing (2457)
Fixed some bugs on OutOfMem (SDAC-1979)
Fixed bug in processing decimals with small precision (2452)

1.80 27-Nov-02

Support 'Connection Timeout' parameter added (Delphi 7 only)
Memory Leaks bug fixed (2246)
EnableBCD setted to True as default
EnableBCD bugs fixed
Support DBMonitor added
Fixed bug with getting position of field in the index (2172)

1.71 15-Oct-02

Fixed bug with int64 parameters
Fixed bug with multiple executing StoredProc which not returning cursor (2125, 2126)
Added HostName parameter to ini files
ConnectionTimeout is changed from infinite to 15 seconds. It is useful for connection with wrong server name (2094)
Fixed bug with system StoredProc describe parameters (2075)
New memory management model for VarBytes types. Allows significantly decrease memory usage on large tables fetch.

1.70 02-Oct-02

Added support HostName parameter for SQLConnection
Delphi7 support
New memory management model for String types. Allows significantly decrease memory usage on large tables fetch.

1.60 05-Sep-02

Increases performance
Additional option FetchAll to TSQLConnection available (1616)
Add support RowsetSize option (1709)
Fixed bug with multithreading (1550, 1602)

1.52 22-Aug-02

BLOB demo added
Fixed bug with bigint fields
Fixed bug with setting ftDate parameter by using AsDateTime property (1533)
Fixed bug with working on CaseSensitive server (1596)

1.51 18-Jul-02

Additional option EnableBCD to TSQLConnection available
Additional option LongStrings to TSQLConnection available
Fixed bug with ftDate parameters

1.50 06-Jun-02

Source code available
Limitation for trial version added
Increases performance
TSQLMonitor support
Changes in core SQL Server classes

1.15 18-May-02

Changes in common classes
Getting additional meta information is disabled

1.14 15-Apr-02

Added ServerName to demos (936)
For DBExpSda driver function GetColumnsRowset is disabled (902)
Correct working with text, ntext parameters (1059)
Optimized query executing
Fixed bug with error processing in MultipleResultSet