且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

具有Office 64位的MS Access DB引擎(32位)

更新时间:2023-02-07 21:47:26

我讨厌回答我自己的问题,但是我终于找到了解决方案实际可行(在服务之间使用套接字通信可能会解决此问题,但会带来更多问题)。由于我们的数据库是旧数据库,因此只需要连接字符串中的 Microsoft.ACE.OLEDB.12.0 。事实证明,这也包含在Office 2007(和MSDE 2007)中,那里只有32位版本可用。因此,我们不是安装32位MSDE 2010,而是安装MSDE 2007 ,效果很好。然后其他应用程序可以安装64位MSDE 2010(或64位Office 2010),它与我们的应用程序没有冲突。

I hate to answer my own questions, but I did finally find a solution that actually works (using socket communication between services may fix the problem, but it creates even more problems). Since our database is legacy, it merely required Microsoft.ACE.OLEDB.12.0 in the connection string. It turns out that this was also included in Office 2007 (and MSDE 2007), where there is only a 32-bit version available. So, instead of installing MSDE 2010 32-bit, we install MSDE 2007, and it works just fine. Other applications can then install 64-bit MSDE 2010 (or 64-bit Office 2010), and it does not conflict with our application.

到目前为止,看来这是适用于所有Windows操作系统环境的解决方案。

Thus far, it appears this is an acceptable solution for all Windows OS environments.