This is the most common use case for legacy applications. You must specify the Provider explicitly.
The OLE DB Driver is not merely a maintenance release; it introduces robust functionalities essential for modern development: microsoft ole db driver for sql server
A common question among developers is: Why use OLE DB today when we have ODBC or .NET Providers? The answer lies in the application ecosystem. OLE DB is a interface, meaning it is deeply integrated into unmanaged C++ applications, older Visual Basic 6.0 systems, SQL Server Integration Services (SSIS), and legacy Analysis Services (SSAS) environments. For these platforms, the Microsoft OLE DB Driver is the recommended, future-proof choice. This is the most common use case for legacy applications