Release notes for the Microsoft OLE DB Driver for SQL Server

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

This page discusses what was added in each version of the Microsoft OLE DB Driver for SQL Server.

18.5.0

download Download x64 installer
download Download x86 installer

Released: December 1, 2020

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added

Feature added Details
Support for SQL Data Discovery and Classification Using data classification
Azure Active Directory Service Principal authentication support (ActiveDirectoryServicePrincipal) Using Azure Active Directory

Bugs fixed

Bug fixed Details
Fixed an issue with embedded NUL characters. Fixed a bug, which resulted in the driver returning an incorrect length of strings with embedded NUL characters.
Fixed a memory leak in the IBCPSession interface. Fixed a memory leak in the IBCPSession interface involving bulk copy operations of sql_variant data type.
Fixed bugs, which resulted in incorrect values being returned for SSPROP_INTEGRATEDAUTHENTICATIONMETHOD and SSPROP_MUTUALLYAUTHENTICATED properties. Previous versions of the driver returned truncated values of the SSPROP_INTEGRATEDAUTHENTICATIONMETHOD property. Also, in the ActiveDirectoryIntegrated authentication case, the returned value of the SSPROP_MUTUALLYAUTHENTICATED property was VARIANT_FALSE even when both sides were mutually authenticated.
Fixed a linked server remote table insert bug. Fixed a bug which caused a linked server remote table insert to fail if the NOCOUNT server configuration option has been enabled.

Previous Releases

18.4.0

download Download x64 installer
download Download x86 installer

Released: May 2020

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added

Feature added Details
Support for Transparent Network IP Resolution (TNIR) Transparent Network IP Resolution (TNIR)
Support for UTF-8 client encoding UTF-8 Support in OLE DB Driver for SQL Server

Bugs fixed

Bug fixed Details
Fixed various bugs in the ISequentialStream interface A few bugs affecting multibyte code pages resulted in the interface prematurely reporting the end of the stream during the read operation.
Fixed a memory leak in the IOpenRowset::OpenRowset interface Fixed a memory leak in the IOpenRowset::OpenRowset interface when the SSPROP_IRowsetFastLoad property was enabled.
Fixed a bug in scenarios involving a sql_variant data type and non-ASCII strings. Executing certain scenarios involving a sql_variant data type and non-ASCII strings may result in data corruption. For details, see: Known issues.
Fixed issues with the Test Connection button in the UDL configuration dialog. The Test Connection button in the UDL configuration dialog now honors initialization properties set in the All tab.
Fixed the SSPROP_INIT_PACKETSIZE property default value handling. Fixed an unexpected error when the SSPROP_INIT_PACKETSIZE property was set to its default value of 0. For details about this property, see Initialization and Authorization Properties.
Fixed buffer overflow issues in IBCPSession. Fixed buffer overflow issues when using malformed data files.
Fixed accessibility issues. Fixed accessibility issues in the installer UI and the SQL Server Login dialog (reading content, tab stops).

18.3.0

download Download x64 installer
download Download x86 installer

Released: October 2019

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added

Feature added Details
Azure Active Directory authentication support (ActiveDirectoryInteractive, ActiveDirectoryMSI) Using Azure Active Directory
Include Azure Active Directory Authentication Library (adal.dll) in the installer Now included in the base driver installation, the OLE DB installer will upgrade existing installations of the Microsoft Active Directory Authentication Library for SQL Server, removing it from the list of installed applications in Windows.
   

Bugs fixed

Bug fixed Details
Fixed drop index logic in IIndexDefinition::DropIndex. Previous versions of the OLE DB driver can't drop a primary key index when the schema ID and the user ID of the owner of the index aren't equal.
   

Download previous OLE DB Driver versions by clicking the download links in the following sections:

18.2.3

download Download x64 installer
download Download x86 installer

Released: June 2019

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added in 18.2.3

Feature added Details
Support for driver upgrades from the SQL Server removable media This improvement allows driver upgrades directly from the SQL Server removable media.
   

18.2.2

download Download x64 installer
download Download x86 installer

Released: May 2019

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Bugs fixed in 18.2.2

Bug fixed Details
Fixed non-interactive Azure Active Directory authentication in multithreaded apartment (MTA). The OLE DB Driver 18.2.1 incorrectly tries to change the COM concurrency model on an apartment that was previously initialized as multithreaded (MTA). As a result, in an application that makes more than one subsequent call to CoInitialize or CoInitializeEx prior to calling the IDBInitialize::Initialize interface, the driver fails to connect when using any of the Azure Active Directory authentication modes.
   

18.2.1

download Download x64 installer
download Download x86 installer

Released: February 2019

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added in 18.2.1

Feature added Details
Support for UTF-8 server encoding UTF-8 Support in OLE DB Driver for SQL Server
Azure Active Directory authentication support Using Azure Active Directory
   

18.1.0

download Download x64 installer
download Download x86 installer

Released: July 2018

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added in 18.1.0

Feature added Details
Support for the UseFMTONLY connection string keyword, and for the SSPROP_INIT_USEFMTONLY initialization property UseFMTONLY controls how metadata is retrieved when connecting to SQL Server 2012 (11.x) and newer.

For more information, see: Using Connection String Keywords with OLE DB Driver for SQL Server.
   

Bugs fixed in 18.1.0

Bug fixed Details
Fixed incorrect version of the BCP format file. The OLE DB Driver 18.0 incorrectly sets the version of the BCP format file to 18.0, instead of to 11.0.
Format files generated by the OLE DB Driver 18.0 cannot be read by the OLE DB Driver 18.1.
If you need to use format files generated by the previous version of the driver with the new driver, you can manually edit the files to change the version to 11.0.
   

18.0.2

download Download x64 installer
download Download x86 installer

Released: March 2018

If you need to download the installer in a language other than the one detected for you, you can use these direct links.
For the x64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the x86 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Features added in 18.0.2

Feature added Details
Support for the MultiSubnetFailover connection string keyword, and the SSPROP_INIT_MULTISUBNETFAILOVER initialization property. For more information, see:
•   OLE DB Driver for SQL Server Support for High Availability, Disaster Recovery,
•   Using Connection String Keywords with OLE DB Driver for SQL Server.
   

See also

Microsoft OLE DB Driver for SQL Server