给定的错误
我在安装Microsoft SQL Server 19 Express时遇到了麻烦同样的事情)。它一直给我带来错误:
错误描述:产品Microsoft的安装程序包
找不到SQL Server的OLE DB驱动程序,尝试再次安装
使用安装PACAKAGE的有效副本'MSOLEDBSQL.MSI'
副本driver-for-sql-server?view = sql-server-ver15“ rel =“ noreferrer”> https://learn.microsoft.com/en-us/sql/sql/connect/connect/oledload-load-load-load-load-load-foriver-for-for-for-for-for-for--driver-for--driver-for- sql-server?view = sql-server-ver15 并运行.msi文件。它运行良好,没有任何错误,但仍无法解决问题。它仍然找不到文件,没有它,我将无法安装程序。还是我正在使用错误的驱动程序?我尝试过的另一件事是单击.msi时,它为我提供了删除或维修的选项。我也做过(在删除后重新安装),但仍然给我带来了错误。在这一点上,我非常非常失落。任何人都可以帮忙吗?
Error given
I am having trouble installing Microsoft SQL server 19 Express (I tired dev aswell, it does the same thing). It keeps giving me the error:
Error Description: An installation package for the product Microsoft
OLE DB Driver for SQL server cannot be found, Try installing again
using a valid copy of the installation pacakage 'msoledbsql.msi'
So what I tried was redownloading it from https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15 and running the .msi file. It runs fine and gives no errors but it still does not fix the issue. It still will not find the file and without it I cannot install the program. Or am I using the wrong driver for it? The other thing I have tried is when clicking on the .msi it gives me the option to remove or repair. I've done both as well (reinstalling after remove) but it still gives me the error. I'm very very lost at this point. Could anyone possibly help?
发布评论
评论(4)
我设法修复了它,首先,您需要转到程序和功能,并卸载在那里的“ SQL Server的Microsoft Ole DB驱动程序”,然后让安装程序安装新的一个
I managed to fix it, first, you need to go to programs and features and uninstall the "Microsoft OLE DB Driver for SQL Server" that is there and then let the installer install the new one
我们正在尝试在现有服务器上安装SQL Server 2019开发人员版,该版本已经安装了标准版,并且我们遇到了以下错误:
解决方案:OLEDB和ODBC驱动程序已经安装在服务器上,因此我首先卸载了它们,然后我可以安装SQL Server 2019开发人员版。
因此,我们始终必须首先卸载现有的OLEDB和ODBC驱动程序,因为SQL Server设置安装了OLEDB和ODBC驱动程序本身。
We were trying to install SQL Server 2019 Developer Edition on our existing server which already had the Standard edition installed earlier and we were getting the below error:
Solution: The OLEDB and ODBC drivers were already installed on the server so I first uninstalled them, then I was able to install SQL Server 2019 Developer Edition.
So we always have to uninstall the existing OLEDB and ODBC drivers first because the SQL Server setup installs the OLEDB and ODBC drivers itself.
尝试安装SQL Server 2022开发人员版时,我也会遇到类似的错误。当我尝试安装OLEDB驱动程序时,它给了我错误,因为它需要VC ++重新分布。我尝试安装X64版本VC ++ REDISTRIBUTABLE(),但仍有同样的错误。最后,当我使用
I was getting similar error when trying to install SQL Server 2022 developer edition. When I tried to install OLEDB driver, It gave me error that it needs VC++ redistributable. I tried to install X64 version VC++ redistributable (https://aka.ms/vs/17/release/vc_redist.x64.exe) but was still getting same error. Finally, this error was fixed when I installed 32 bit version using https://aka.ms/vs/17/release/vc_redist.x86.exe
我删除了所有“ Microsoft ODBC驱动程序”和“ Microsoft ODBC驱动程序” S,然后使用了SQL Server的新安装。安装它后,我在程序和功能中有2个新的“ OBCD驱动程序” S和一个“ SQL Server的旧DB驱动程序”。请注意,在安装后,我现在安装了大约25种不同的“ Microsoft SQL Server”,从“ 2008”到“ 2022”。
I deleted ALL "Microsoft ODBC Driver"s and "Microsoft ODBC Driver"s and then the new install of SQL Server worked. After installing it, I had 2 new "OBCD Driver"s and one "OLD DB Driver for SQL Server" in Programs and Features. And note, after the install, I now had about 25 different "Microsoft SQL Server"s installed,from "2008" to "2022".