郑德才博客

我在WIN7 64位下使用ACCESS作为网站数据库运行程序的时候，网页报错如下：

“The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine”

查了一下原因是WINDOWS 64X不支持 JET OLEDB 4.0，试了很多办法来让其运行正常都未果。刚在国外的论坛找到了解决办法：

ASP.NET/IIS Fix: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

In my latest ASP.NET project, I refresh the sample data using an Excel spreadsheet from the client. After upgrading to Windows Server 2008 R2, I suddenly discovered this error:

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

The error message is totally bogus! The problem is that I’m running IIS on a 64-bit machine and the ol’ OLEDB thingy just isn’t up with the times.

To fix it, go into the IIS Manager and find out which Application Pool the site is using. In my case, it’s called “ASP.NET V2.0”. Next, go to the Application Pools node, and investigate the aforementioned app pool’s advanced settings.

The property Enable 32-Bit Applications needs to be set to True.

I’m sure I’ve run across this before but hadn’t retained the fix. Now it’s where I can find it.

Ken

原文地址：http://weblogs.asp.net/kencox/archive/2010/05/20/asp-net-iis-fix-the-microsoft-jet-oledb-4-0-provider-is-not-registered-on-the-local-machine.aspx