"找不到提供者.它可能未正确安装".在64位上构建时 [英] "Provider cannot be found. It may not be properly installed" when built on 64 bit

问题描述

我正在使用ADO连接到EXCEL.在我的机器办公室中，安装了32位.使用32位代码时，以下代码可以正常运行:

I'm using ADO to connect to EXCEL. On my machine office 32 bit is installed. The following code runs fine when built with 32 bit:

_ConnectionPtr conn;
conn->Open(connStr, "", "", NULL);

连接字符串包括:

Provider=Microsoft.ACE.OLEDB.12.0

当编译为64位时，我得到:找不到提供程序.它可能未正确安装."(hr = -2146824582).64位存在兼容性问题吗?我应该安装64位Office吗?如果这样做，我的代码在构建为32位时可以正常工作吗?

When compiled for 64 bit I get: "Provider cannot be found. It may not be properly installed." (hr=-2146824582). Is there a compatibility issue with 64 bit? Should I install 64 bit office? If I do, will my code work when built for 32 bit?

谢谢.

推荐答案

解决方案:"Microsoft Access Database Engine 2010可再发行".

Solution: "Microsoft Access Database Engine 2010 Redistributable".

从 http://www下载"AccessDatabaseEngine_X64.exe".microsoft.com/en-gb/download/details.aspx?id = 13255 并运行"AccessDatabaseEngine_X64.exe/passive".

Download "AccessDatabaseEngine_X64.exe" from http://www.microsoft.com/en-gb/download/details.aspx?id=13255 and run "AccessDatabaseEngine_X64.exe /passive".

这篇关于"找不到提供者.它可能未正确安装".在64位上构建时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！