Release notes for the Microsoft OLE DB Driver for SQL Server

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

DownloadDownload OLE DB Driver

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

18.3.0

October 2019

Features added

Feature added Details
Azure Active Directory authentication support (ActiveDirectoryInteractive, ActiveDirectoryMSI). Using Azure Active Directory.
Support for embedded Active Directory Authentication Library (ADAL). A separate installation of ADAL isn't required anymore to use certain authentication methods.
   

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.
   

18.2.3

June 2019

Features added

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

May 2019

Bugs fixed

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

February 2019

Features added

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

July 2018

Features added

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

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

Features added

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