无法找到提供商 [英] Provider cannot be found
问题描述
我有一个拥有x64 win 7机器的客户端和x32办公室他们也使用autocad。
I have a client who has x64 win 7 machines and x32 office they also use autocad.
我刚开发了一个.net插件到autocad访问了一个。 mdb文件和excel电子表格。当autocad安装为x32时，一切正常。
I developed a while ago a .net addin to autocad that accessed a .mdb file and an excel spreadsheet. all worked fine while autocad was installed as x32.
最新版本的autocad仅在x64 windows上使用x64。
latest versions of autocad are x64 only on x64 windows.
我有一个VM开发测试环境那是
I have a VM development test environment that is
win7 pro x64
win7 pro x64
autocad 11 x64
autocad 11 x64
office 2010 x32
office 2010 x32
似乎一切正常，除非我尝试使用ADODB连接字符串"提供程序 = Microsoft.ACE.OLEDB.12.0;
all seems to work ok except when I try and MS Access file using ADODB connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\server\share\folder\myAccessFile.accdb;"
我收到来自的错误消息ADODB"错误状态 - 无法找到提供程序。它可以正确安装。"
I get error message from ADODB "error state - Provider cannot be found. It may be properly installed."
当我尝试使用管理工具>查看odbc时出现同样的错误数据源（odbc）然而我知道如果你使用odbc管理器的WOW64版本你就不会收到错误。
I get same error when I try to look at odbc using administrative Tools> data sources (odbc) however I am aware that if you use the WOW64 version of the odbc manager you do not get error.
所以我相信我的问题是 - 我如何得到我的应用程序使用x32 ACE驱动程序，而不是它似乎试图使用的X64。
So I believe my problem is - how do I get my app to use the x32 ACE drivers and not the X64 that it appears to be trying to use.
VS设置"任何cpu"和"x64"似乎没有任何影响
VS settings "any cpu" and "x64" do not seem to have any affect
非常感谢任何帮助。
推荐答案
ACE 12是2007版。没有64位Office 2007，所以有理由认为2007年没有64位ACE。
你需要2010或更高版本（14），这是一个单独的下载，除非你已经有64位办公室安装。抱歉，没有方便的链接。
请注意，64位驱动程序与同一台计算机上的Office 32位安装不兼容。
ACE 12 is 2007 version. There is no 64bit Office 2007, so it stands to reason that there is not 64bit ACE for 2007.
You would need 2010 or later version (14), which is a separate download unless you already have 64bit Office installed. Sorry, don't have the link handy.
Note that 64bit driver is not compatible with Office 32 bit installation on the same machine.
这篇关于无法找到提供商的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
