Forum Discussion

Jose_Carlos_Salazar's avatar
Jose_Carlos_Salazar
Copper Contributor
May 24, 2023

Problem with SQLOLEDB

Hi all:

 

We are having a problem with an old application (32 bits) that needs to establish an ADO connection from a Windows Server 2016 to a MS SQL Server 2019 (in another Windows Server 2016) using SQLOLEDB as provider. I know we should use MSSQLOLEDB instead, but that app really needs the old SQLOLEDB. In the network, TLS 1.0 and 1.1 are disabled. We have a few servers the same SO where the app is working fine using TLS 1.2, with de dll version 10.0.14393.5850. But in one of them, we get the message: "Provider cannot be found. It may not be properly installed". We have SQLOLEDB.DLL in C:\Program Files (x86)\Common Files\System\Ole DB and SQLSRV32.DLL in C:\Windows\SysWOW64.

 

I can not find an installer for the correct provider.

 

Any idea?

Jose Carlos Salazar

Resources