Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册 [英] Microsoft.ACE.OLEDB.12.0 Provider is not registered on the local computer
问题描述
您好,
我已安装以下软件进行编程和访问数据库。一切都是德语安装和消息从我这边翻译。
I have the following Software installed for programming and accessing a database. Everything is in german installed and Messages are translated from my side.
Office 2016 64bit with Access
Office 2016 64bit with Access
Visual Studio 2015 Express
Visual Studio 2015 Express
Microsoft Access Runtime 2016
Microsoft Access Runtime 2016
Microsoft数据库引擎2010
Microsoft Database Engine 2010
Microsoft数据库引擎2007
Microsoft Database Engine 2007
因为我已经安装了"Microsoft Database Engine 2007"我能够在Visual Studio 2015中连接Access 2016.accdb数据库。
Since I have installed the "Microsoft Database Engine 2007" I was able to connect an Access 2016 .accdb DB within Visual Studio 2015.
我能够在Visual Studio的左窗格中看到所有表,行等...(测试连接成功)
I was able to see all tables, rows etc... on the left pane of the Visual Studio ( Test Connection SUCCESSFUL)
但现在我将在代码中尝试访问刚开始使用"
But now I will try within the Code to acces the table on the DB just started with "
" Provider = Microsoft.ACE.OLEDB.12.0 " & "数据
来源= C:\ Temp \ Test.accdb"
$
不幸的是,这会错误地使用errorBox"'Microsoft.ACE.OLEDB.12.0 DATA Source = ....." - 提供商不是本地
注册
"Provider=Microsoft.ACE.OLEDB.12.0"&"Data
Source=C:\Temp\Test.accdb"
Unfortunately this failes with the errorBox "The 'Microsoft.ACE.OLEDB.12.0 DATA Source=....." - Provider is not locally
registered
我不知道为何会出现此消息Pop我再次在数据库对象浏览器中与Access数据库建立了良好的连接,为什么这个
不能再次运行。在这种形式下找出安装" Microsoft Database Engine 2007"的确是一种情况。解决Access 2016问题,但现在再次相同。
I have no idea why this message Pop up again either I have a good Connection to the Access DB within the Database Object browser, why does this not work again. It was really a circumstance to find out in this form to install the "Microsoft Database Engine 2007" to Workaround the Access 2016 Problem but now the same again.
请帮助解决此问题!
祝你好运
Alex
推荐答案
尝试更改平台(构建......配置 管理器...) 您的项目到x86,以便它运行32位。听起来好像应用程序正在运行64位(任何CPU或x64)并且未安装该版本的提供程序。
Try changing the Platform (Build...Configuration Manager...) of your project to x86 so that it runs 32-bit. It sounds to me as if the app is running 64-bit (Any CPU or x64) and that version of the provider is not installed.
这篇关于Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!