While installing SQL Server Express 2022 I ran into several issues because the MS OLEDB and MS ODBC SQL drivers were not available. You expect these to be part of the SQL Express installer, but they are not. When you install these separately you will find that you also need the Visual C++ Redistributable. When installing the latest version you will find that it still not works. This is how you can solve it:
- Install the x64 version of the Visual C++ Redistributable
- Install the x68 version of the Visual C++ Redistributable
- Install the MS OLE DB driver
- Install the MS ODBC SQL driver
The important thing here is that you need both the x64 and the x68 versions of the Visual C++ redistributable, while that is never clear from the error messages. When all this has been completed you can run the SQL Server Express 2022 installer.
Note: If you still run into issues then make sure any existing OLEDB and ODBC drivers from Add or Remove Programs.