Can't install msoledbsql - get error saying it needs C++ Redist

Question

I'm trying to make our (Installshield) installers use msoledbsql instead of sqloledb and sqlncli11 and the installer fails when connecting to the database. So I did some research and tried manually installing msoledbsql first (using msoledbsql.msi), but I get the error: The application requires Visual C++ Redistributable for Visual Studio 2022, version 14.34 at minimum. So I downloaded and installed Microsoft Visual C++ 2015-2022 Redistributable (x64) - 14.36.32532, but I still get the same message, even after rebooting.

I tried adding both as redistributables (pre-reqs), but I get the same issue.

Anyone come across this and know what's going on?

Answer 1

I found that we needed both the x86 and x64 C++ redistributables as prerequisites. Also the checksum's in the .prq files are wrong, so the xml needed updating with the MD5 hash of the downloaded files:

certutil -hashfile VC_redist.x86.exe MD5

certutil -hashfile VC_redist.x64.exe MD5

Hope that helps