Release notes for the Microsoft OLE DB Driver for SQL Server
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
This page discusses what was added in each version of the Microsoft OLE DB Driver for SQL Server.
19.3.3
Download x64 installer
Download x86 installer
Download Arm64 installer
Released: April 09, 2024
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
For the Arm64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
| Fixed a bug in UDL dialog. | Fixed a screen reader double read bug in UDL. |
| Fixed a bug in connection recovery mode. | Fixed a race condition during disconnect while in connection recovery mode. |
Previous releases
19.3.2
Download x64 installer
Download x86 installer
Download Arm64 installer
Released: October 10, 2023
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
For the Arm64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added
| Feature added | Details |
|---|---|
| Error message improvement | Improved MARS and encryption related error messaging. |
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
19.3.1
Download x64 installer
Download x86 installer
Download Arm64 installer
Released: June 15, 2023
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
For the Arm64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
19.3.0
Download x64 installer
Download x86 installer
Download Arm64 installer
Released: February 14, 2023
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
For the Arm64 driver: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Features added
| Feature added | Details |
|---|---|
| Windows Arm64 support | The Arm64 driver is for 64-bit ARM applications only and does not include 32-bit ARM nor x86/x64 emulation drivers. |
| Visual Studio 2022 build toolset upgrade | The driver now requires Microsoft Visual C++ Redistributable for Visual Studio 2022 (version 14.34 at minimum). |
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
| Fixed adal issue. | Fixed an installer issue where a 64-bit version of adal.dll was packaged instead of the 32-bit one. For details, see Known issues. |
19.2.0
Download x64 installer
Download x86 installer
Released: October 26, 2022
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 TLS 1.3 | TDS 8.0 connections can now be configured to use TLS 1.3. For more details, see TLS 1.3 support. |
Support for the Server Certificate connection string keyword, and the SSPROP_INIT_SERVER_CERTIFICATE initialization property |
The user may now specify the path to a certificate file to match against the SQL Server TLS/SSL certificate. For more information, see: Using connection string keywords. |
19.1.0
Download x64 installer
Download x86 installer
Released: August 31, 2022
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 |
|---|---|
| Application-Layer Protocol Negotiation (ALPN) extension | The driver implements the Application-Layer Protocol Negotiation (ALPN) extension when the TDS 8.0 protocol is used. |
Bugs fixed
| Bug fixed | Details |
|---|---|
Fixed an issue where the SSPROP_INIT_AUTOTRANSLATE property was ignored for SSVARIANT narrow string values. |
Fixed a bug where setting SSPROP_INIT_AUTOTRANSLATE to VARIANT_FALSE would result in character translations for SSVARIANT narrow string values. |
| Fixed an issue with missing digital signatures. | Added digital signatures for the installer custom action dynamic-link libraries. |
| Fixed an issue with HostnameInCertificate property being passed through the Server Name Indication (SNI) TLS extension. | The HostnameInCertificate value is no longer present in the Server Name Indication (SNI) TLS extension. |
| Restored the functionality of the Protocol Order and the TCP Keep-Alive registry properties. | The driver now adjusts the TCP Keep-Alive and the Protocol Order properties based on the values set for the corresponding registry entries. |
19.0.0
Download x64 installer
Download x86 installer
Released: February 15, 2022
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 |
|---|---|
| TDS 8.0 support | The encryption connection string keyword/property now includes the option for strict encryption, which encrypts the whole connection (including PRELOGIN packets). |
| Secure by default | BREAKING CHANGE The driver now defaults to secure-by-default options. Encrypted connections are enabled by default. The server certificate is now validated when client-side encryption is off but the server requires encryption. To restore previous version behavior, you need to opt in to non-encrypted connections ( Encrypt or Use Encryption for Data option) and trust the server certificate (Trust Server Certificate option), if the server uses a self-signed certificate. For more information, see Encryption and certificate validation. |
Support for the Host Name In Certificate connection string keyword, and the SSPROP_INIT_HOST_NAME_CERTIFICATE initialization property. |
The user may now specify the host name to be used when validating the SQL Server TLS/SSL certificate. |
18.7.2
Download x64 installer
Download x86 installer
Released: April 09, 2024
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
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
| Fixed a bug in UDL dialog. | Fixed a screen reader double read bug in UDL. |
| Fixed a bug in connection recovery mode. | Fixed a race condition during disconnect while in connection recovery mode. |
18.6.7
Download x64 installer
Download x86 installer
Released: October 10, 2023
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
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
18.6.6
Download x64 installer
Download x86 installer
Released: June 15, 2023
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
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
18.6.5
Download x64 installer
Download x86 installer
Released: December 15, 2022
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
| Bug fixed | Details |
|---|---|
| Fixed potential crashes. | Fixed potential crashes when invalid metadata is received from the server. |
18.6.4
Download x64 installer
Download x86 installer
Released: August 31, 2022
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
| Bug fixed | Details |
|---|---|
Fixed an issue where the SSPROP_INIT_AUTOTRANSLATE property was ignored for SSVARIANT narrow string values. |
Fixed a bug where setting SSPROP_INIT_AUTOTRANSLATE to VARIANT_FALSE would result in character translations for SSVARIANT narrow string values. |
| Fixed an issue with missing digital signatures. | Added digital signatures for the installer custom action dynamic-link libraries. |
18.6.3
Download x64 installer
Download x86 installer
Released: December 15, 2021
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 |
|---|---|
| Removal of dependency on vcruntime140_1.dll | To remove the requirement to install Visual Studio in some scenarios, we removed all dependencies to vcruntime140_1.dll. |
| Enable querying server SPN from connection | During a connection attempt where Azure AD authentication has been selected, the server will send a FEDAUTHINFO packet. This packet contains the server's SPN that must be used to generate the access token. Clients can query this value after a connection attempt is made (on success or failure) through the SSPROP_INIT_DISCOVERDSERVERSPN property in DBPROPSET_SQLSERVERDBINIT. |
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed an issue where string values were being padded with zeros. | Fixed a bug, which resulted in empty fixed char fields being padded with zeroes during BCP import. |
18.6.0
Download x64 installer
Download x86 installer
Released: June 18, 2021
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 Idle Connection Resiliency | Idle Connection Resiliency in the OLE DB Driver |
| Removal of dependency on SQL Server tools while reading BCP XML format files | SQL Server tools is no longer required in order to read BCP XML format files. For more information, see the BCP_OPTION_FMTXML option for IBCPSession::BCPControl. |
Bugs fixed
| Bug fixed | Details |
|---|---|
| Fixed an issue with endianness of port numbers in data access trace logs. | Fixed a bug, which resulted in port numbers logged having incorrect endianness while doing Data Access Tracing. |
| Fixed an accessibility issue. | Fixed an accessibility issue in the user interface of Universal Data Link (UDL). This accessibility issue resulted in the Browse button not being announced by screen reader software. |
| Fixed crash in scenarios involving Multiple Active Result Sets. | Fixed a bug, which could result in the driver crashing in some scenarios involving Multiple Active Result Sets (MARS). |
18.5.0
Download x64 installer
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. |
18.4.0
Download x64 installer
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 x64 installer
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 x64 installer
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 x64 installer
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 x64 installer
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 x64 installer
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 x64 installer
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
MSOLEDBSQL major version differences
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for