Skip to content

Latest commit

 

History

History
29 lines (22 loc) · 1.87 KB

oledb-driver-for-sql-server-known-issues.md

File metadata and controls

29 lines (22 loc) · 1.87 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic
Microsoft OLE DB Driver for SQL Server known issues
Learn about known issues and fixes for the Microsoft OLE DB Driver for SQL Server.
David-Engel
davidengel
wiassaf
01/24/2024
sql
connectivity
reference

Microsoft OLE DB Driver for SQL Server known issues

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

[!INCLUDEDriver_OLEDB_Download]

This article contains a list of known issues and fixes for the Microsoft OLE DB Driver for SQL Server.

Known issues

  • The driver returns the following error message: Error loading adal.dll from system directory. Verify that Active Directory Authentication Library for SQL Server is properly installed. The most likely cause of this error is incorrect bitness of adal.dll. It can be caused by the installation of version 19.2.0 of the OLE DB Driver. Version 19.2.0 erroneously places a 64-bit ADAL library into the 32-bit system directory. To resolve this issue, install the OLE DB Driver version 19.3 or higher. It includes ADAL 3.6.1 with the correct bitness.
  • Currently, MSOLEDBSQL19 prevents the creation of linked servers without encryption and a trusted certificate (a self-signed certificate is insufficient). For more information, see Linked servers.
  • Use of MSOLEDBSQL19 within a linked server is only supported on SQL Server 2022 or newer.

Next steps