Microsoft ACE.OLEDB12.0提供程序未在此本地计算机上注册 [英] Microsoft ACE.OLEDB12.0 provider not registered on this local machine
问题描述
我在使用Windows 10的Dell XPS 8900上运行。 在Visual Studio 2015中工作,尝试连接到我的OFFICE 2016设置中的Access数据库。 根据我在MSDN网站上看到的内容,我怀疑ACEOLEDB.DLL可能无法找到
。 我按照路径
I am Running on a Dell XPS 8900 using Windows 10. Working within Visual Studio 2015 trying to connect to an Access DB that is part of my OFFICE 2016 setup. From what I have read on the MSDN website I am suspicious that perhaps ACEOLEDB.DLL cannot be located. I followed the path
C:/ ProgramFilesX86 / CommonFiles / Microsoft Shared / OFFICE16 /
C:/ProgramFilesX86/CommonFiles/Microsoft Shared/OFFICE16/
并且DLL不存在。 我甚至检查了
and the DLL was not there. I even checked
C:/ ProgramFiles / CommonFiles / Microsoft Shared /
C:/ProgramFiles/CommonFiles/Microsoft Shared/
并且根本没有OFFICE16(毫不奇怪)。
and there was no OFFICE16 there at all (no surprise).
我有256千兆字节固态引用为我的D盘。 它有 路径下的ACEOLEDB.DLL文件
I have a 256 gigabyte solid state referenced as my D drive. It has the ACEOLEDB.DLL file on it under the path
D:/ ProgramFilesX86 / CommonFiles / microsoft shared / OFFICE12 /
D:/ProgramFilesX86/CommonFiles/microsoft shared/OFFICE12/
我尝试将此文件移动到OFFICE16目录但这没有帮助。
I tried moving this file to the OFFICE16 directory but that did not help.
任何关于造成错误的原因,此时的建议是什么?
Any suggestions at this point as far as what is causing the error?
Frank
friedman@temple.edu
friedman@temple.edu
推荐答案
Hi ImRetired,
Hi ImRetired,
Windows操作系统上未安装ACE提供程序默认情况下。你必须安装它。 ACE提供程序有两种形式:
Microsoft Office Access数据库引擎2007 和
Microsoft Access数据库引擎2010可再发行组件。 2007版本仅作为32位组件提供,而2010版本提供32位和64位选项。你需要
来注意你选择哪个选项,因为这里错误的选择是导致错误信息的最常见原因。
The ACE provider is not installed on Windows operating systems by default. You have to install it. The ACE provider is available in two forms: Microsoft Office Access database engine 2007 and the Microsoft Access Database Engine 2010 Redistributable. The 2007 version is only available as a 32-bit component whereas the 2010 version offers both 32 and 64-bit options. You need to be careful which option you choose, because a wrong choice here is the most frequent cause for the error message.
祝你好运,
Cole Wu
这篇关于Microsoft ACE.OLEDB12.0提供程序未在此本地计算机上注册的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!