即使实际安装了Microsoft.ACE.OLEDB.12.0提供程序也未在本地计算机上注册 [英] The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine even if it actually IS installed
问题描述
我尝试将.accdb文件作为数据源连接到Visual Studio中的Windows窗体应用程序.它一直说Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册.
I try to connect .accdb file as a data source to my Windows Form application in Visual Studio. It keep saying the Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
我已在标记为已接受/正在工作"的相关答案上安装了所有建议的运行时:
I have installed all the recommended runtimes on related Answers marked as Accepted/working:
- Microsoft Access数据库引擎2010(x64)
- Microsoft Access数据库引擎2016(x64)
- Microsoft Access Runtime 2010(x64)
- Microsoft Access Runtime 2013(x64)
但仍然是同一问题.
在Windows Forms项目中设置x86/x64平台无济于事.
Setting the x86/x64 platform in Windows Forms project did not help.
设置:
- Microsoft Windows 10 64位版本1809内部版本17763.437
- Microsoft Visual Studio 2015 14.0.25431.01更新3
推荐答案
平台真的很奇怪.我已在64位中安装了所有必需的可用组件,并且连接导致"Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册".
There really is strange mixture of platforms. I have installed all the necessary available within 64 bit and the connection resulted in "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine".
当我尝试安装86位版本时,我得到了"您无法安装32位版本的Microsoft Access数据库引擎,因为您当前安装了64位Office产品... ": 设置运行时错误
When I tried to install the 86 bit version, I got the "You cannot install the 32-bit version of Microsoft Access Database Engine because you currently have 64-bit Office products installed...": Setup Runtime error
我按照 Merav Kochavi的建议使用/passive参数(" AccessDatabaseEngine.exe/passive ")运行了32位版本设置,但没有错误消息,现在可以正常工作! 测试连接成功.
I followed the Merav Kochavi's advice to run the also the 32 bit version setup using /passive parameter ("AccessDatabaseEngine.exe /passive") and it went without the error message and now IT WORKS! Test connection succeeded.
谢谢大家的帮助!
这篇关于即使实际安装了Microsoft.ACE.OLEDB.12.0提供程序也未在本地计算机上注册的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!