Microsoft Ole Db Driver For Sql Server 2019 ((exclusive)) -
The version of the OLE DB driver included with SQL Server 2019 (primarily version 18.x) follows a support lifecycle aligned with the database engine itself. While SQL Server 2019 ended its , the driver remains supported through the extended support phase of the server. Driver History for Microsoft SQL Server
But the application was broken.
Note: The Provider string is exactly MSOLEDBSQL19 (case-sensitive). microsoft ole db driver for sql server 2019
Native support for Azure SQL Database, Azure SQL Managed Instance, and Microsoft Entra ID (formerly Azure Active Directory). The version of the OLE DB driver included
Connecting... Handshake successful. TLS Secure Channel Established. Query Executed. Handshake successful
Test MSOLEDBSQL19 in a staging environment, update your connection strings, and retire the ancient SQLNCLI providers. Your future self—and your security team—will thank you.
He opened the web.config file. He deleted the old, crusty reference: Provider=SQLOLEDB .