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

I had a basic problem recently porting an ASP.NET application from 32 bit Windows 2003 to a virtual environment running Windows 64 bit.

The ASP.NET application was pretty basic and it worked with a MS Access backend.

I was using OLEDB Provider to connect from ASP.NET to the backend database

But as it turns out there is no version of JET for Windows 64 bit.

So you have to disable 64 bit ASP.NET under IIS and enable 32 bit ASP.NET under IIS.

Here are the steps I followed.

To run the 32-bit version of ASP.NET 2.0, follow these steps.  This was based on ASP.NET 2.0.50727

  1. Start / Run  / cmd
  2. cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET   W3SVC/AppPools/Enable32bitAppOnWin64 1
  3. %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
Note
One thing I missed, again simple but is to make sure that the 64 bit version of ASP.NET is prohibited and the 32 bit is allowed under the IIS web service extension list.

Comments

Popular posts from this blog

Basic Send Message to MQ with Java and IBM MQ JMS

Basic Receive Message to MQ with Java and IBM MQ JMS

Creating a simple Alert / Success Message with ASP.NET/VB using Bootstrap