带有Win 7的64位计算机的MS Access Provider [英] MS Access Provider for 64 bit machine with Win 7

问题描述

如何在64位计算机上从VB.Net应用程序连接MS-Access数据库?

我无法从vb.net应用程序连接MS Access数据库(.mdb).我的机器是64位的，操作系统是Windows7.我已将连接字符串用作提供程序"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\ Setup.mdb"

How can i connect MS-Access database from VB.Net application in my 64 bit machine?

I can not connect with MS Access database (.mdb) from my vb.net application. My machine is 64 bit and OS Windows 7. I have use the connection string as provider "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\Setup.mdb"

推荐答案

尝试:
将项目编译到X86 CPU并安装32位oledb提供程序.

Try:
Compile your project to X86 CPU and Install 32 bit oledb provider.

"Microsoft.Jet.OLEDB.4.0"提供程序仅是32位. 64位应用程序无法使用它.

您要么必须使用兼容64位的其他提供程序，即"Microsoft.ACE.OLEDB.12.0"(Access 2007及更高版本)，要么将应用程序重新编译为仅针对x86.

The "Microsoft.Jet.OLEDB.4.0" provider is 32-bit only. 64-bit applications cannot use it.

You either have to use a different provider that is 64-bit compatible, namely "Microsoft.ACE.OLEDB.12.0" (Access 2007 and higher), or recompile your app to target x86 only.

这篇关于带有Win 7的64位计算机的MS Access Provider的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！