Forum Discussion
Jose_Carlos_Salazar
May 24, 2023Copper Contributor
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
- TomH_SWCopper Contributor
Hello.
Did you manage to find a solution? I have the same situation, on some machines with the same operating system (Win11) the application reports "Provider cannot be found".
At the same time, it is possible to establish a connection to the server via the SQLSRV32.DLL/SQLOLEDB combination normally from the ODBC Sources.
I will be grateful for any direction.
Have a nice day, Tom Hudec- Jose_Carlos_SalazarCopper Contributor
Hello:
No, I could not solve the problem. Finally, I'm using SQLNCLI1.1 and make some changes in my Crystal Reports reports to use it.
But SQLOLEDB works fine in Windows Server 2019 and 2022, so I think it would work on W11. I only have this problem with Windows Server 2016.
Greetings,
José Carlos
- Jos_Carlos_SalazarCopper ContributorHi:
Thanks. We will try. But , honestyl, I am not sure we've done it yet...
Regards,
Jose CarlosSounds good, please don't forget to close up the thread here by marking helpful replies.