“Microsoft.ACE.OLEDB.12.0未在本地机器上注册。” [英] 'Microsoft.ACE.OLEDB.12.0 is not registered in the local machine.'
问题描述
我已经安装了Microsoft Access数据库引擎2010可再发行的http：/在Windows 2008服务器上/www.microsoft.com/en-us/download/details.aspx?id=13255 。然而，当我跑我的web应用程序导入A S preadsheet表到数据库中。它与抱怨错误消息 - Microsoft.ACE.OLEDB.12.0未在本地机器上注册了
I have installed Microsoft Access Database Engine 2010 Redistributable http://www.microsoft.com/en-us/download/details.aspx?id=13255 on the Windows 2008 server. However, when I ran my web application to import a spreadsheet table to the database. It complains with the error message - "Microsoft.ACE.OLEDB.12.0 is not registered in the local machine."
我过我的code和工作在我的Windows 7本地机器上。任何想法？
I have tested my code and works in my Windows 7 local machine. Any idea?
推荐答案
有一个问题是 Microsoft.ACE.OLEDB.12 在 AccessDatabaseEngine x86或x64 2010 的已安装。
There is a problem with Microsoft.ACE.OLEDB.12 when AccessDatabaseEngine x86 or x64 2010 is installed.
我一直试图使用SSMS（2005-2008-2008R2-2012）出口奇才大表导出到Excel中，我需要安装AccessDatabaseEngine才能够做到这一点。
I have long attempted to use the SSMS (2005-2008-2008R2-2012) Export Wizards to export large tables onto Excel and I needed the AccessDatabaseEngine installed to be able to do that.
然而，无论MS Office版本（2010年，x86或x64，或不管它是什么），2010版AccessDatabaseEngine不会对注册供应商合作。
However, regardless of the MS Office version (2010, x86 or x64, or whatever it is), the 2010 version of AccessDatabaseEngine will not work towards registering the provider.
解决方案是下载并安装previous其中一个不是别人，正是在 2007年86 之一。
这人会工作，即使Office或SQL Server或VS是64位。
The solution is to download and install the previous one which is none other than the 2007 x86 one. This one will work even if Office or SQL Server or VS are x64.
从这里 http://www.microsoft下载。 COM / EN-US /下载/ confirmation.aspx？ID = 23734
现在，周围的臭名昭著的失败循环任何其它传播问题，注册的提供者本地计算机的Microsoft.ACE.OLEDB.12上应该由上面来解决。
Now, any other propagated issues revolving around the notorious failure to register "the provider" on the local machine for the Microsoft.ACE.OLEDB.12 should be resolved by the above.
随意粘贴我在这个问题上的经验。
Feel free to paste me your experiences on this matter.
这篇关于“Microsoft.ACE.OLEDB.12.0未在本地机器上注册。”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
