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

Published Thursday, May 20, 2010 9:13 PM by Ken Cox [MVP]
Filed under: , , , ,

Comments

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

Friday, May 21, 2010 12:41 AM by rajbk

Ken,

I have not tried this myself but you should be able to use the "Microsoft Access Database Engine 2010 Redistributable" 64 bit version.

www.microsoft.com/.../details.aspx

using

Provider=Microsoft.ACE.OLEDB.12.0

Raj Kaimal

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

Sunday, May 23, 2010 4:06 PM by Hemal Gala

I have received this error on a Windows App. I am running a 64-bit OS. any ideas for a solution here?

When I took my app to a 32-bit OS, everything worked just as expected

Thanks in advance

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

Tuesday, June 08, 2010 4:22 PM by Sami

I got this error message while running a asp.net page via IIS on (windows 7).  I went into the Application Pool, clicked on my pool (in my case Test) and right clicked.  I selected 'Set Application Pool Defaults'.

Change the 'Enable 32 bit Application' to True.  

Hope it works.  

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

Monday, August 23, 2010 4:18 PM by PCPGMR

The change on setting 64 to 32 bit in IIS worked for me.

FYI

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

Friday, September 24, 2010 3:39 PM by Jim

If your web server created an application pool for your site, change the "Enable 32-Bit Applications" setting in that pool specifically as well as the default pool.  That's what ultimately worked for me.

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

Thursday, September 30, 2010 7:41 AM by Vaibhav

Ken,

Thanks for the solution. It worked perfectly.

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

Thursday, October 28, 2010 7:07 AM by Bob@Sapphire

Wow. You just saved me a lot of wasted time... Thanks!

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

Tuesday, January 04, 2011 5:11 AM by frederic.delhaye@itga.fr

thanks for sharing.

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

Friday, March 04, 2011 5:24 PM by Kevin

Great tip!  I would never have found that on my own!

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

Friday, March 11, 2011 11:20 AM by john

Thanks for the info, you saved us a lot of hassle!  

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

Tuesday, March 29, 2011 7:12 PM by smcmiata

It did not work for me. I'm running asp.net 4.0, Managed pipeline = Classic. Any other suggestions?

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

Tuesday, March 29, 2011 7:15 PM by smcmiata

OH, also running IIS 7.0.

When I do try this fix, the whole site returns the error: "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable."

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

Wednesday, August 31, 2011 12:22 AM by wizdude

you can't change this on an SBS2011 server, however. as soon as you change a .net 2.0 application pool to support 32 bit execution, all of the OWA (outlook web access) services fail so webmail and activesync stop functioning.

i have a separate website with a separate application pool, but it makes no difference. i'm now going to investigate using the Microsoft Access Database Engine 2010 Redistributable which comes in a 64 bit release.

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

Friday, September 30, 2011 4:01 AM by ayuayek

Thanks a lot, it works, I was running MsChart Sample on win7 x64, and got the error. Bogus indeed.

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

Monday, January 02, 2012 7:46 AM by Karthik.M

Very very thanks for your golden information, I fixed this error, Now its working properly.

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

Wednesday, March 28, 2012 3:52 AM by C Johnson

Thanx for the information, fixed the error.

Appreciate it.

Config was IIS 6, Windows 7, Visual Studio 8.

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

Friday, May 11, 2012 1:10 AM by Naren

Asp files are not working while change to 32 bit...

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

Tuesday, June 12, 2012 7:10 AM by Paul Indonesia

Open IIS Manager --> Aplication Pools --> choose your Application Pools Name --> Advanced Setting --> Process Orphaning change the value from false to true. Refresh your application page. It work for me.

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

Thursday, October 18, 2012 2:45 PM by ravishankar

I got the similer error ,we have upgraded server from windows 2003 to 2008 R2 ,we have built applicaiton sin 2.0 frame work windows services , which are failed given error The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Fix ::

1) download  www.microsoft.com/.../details.aspx

"AccessDatabaseEngine_x64.exe"

2)Run the above as administrator

3) change Provider=Microsoft.Jet.OLEDB.4.0;

to

Provider=Microsoft.ACE.OLEDB.12.0;

UPDATE: Microsoft has released a service pack for the

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

Thursday, May 30, 2013 8:10 AM by Giovefi

If You were a girl I'll kiss You !!

Easy and really good !

Thanks.

Leave a Comment

(required) 
(required) 
(optional)
(required)