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) usi...
TomH_SW
Jul 23, 2024Copper 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_SalazarJul 24, 2024Copper 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