Click here to Skip to main content
15,867,704 members
Articles / Web Development / ASP.NET
Tip/Trick

Jet Ole DB 4.0 not registered 64-bt Win 2008

Rate me:
Please Sign up or sign in to vote.
5.00/5 (3 votes)
31 Jul 2011CPOL 55.3K   10   2
When running an ASP.NET application under 64-bit Win7/2008 you get jet 4.0 not registered error
I lost some time this morning due to this exception:

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

My scenario is that I have migrated a asp.net website from an aging Windows 2003 bit server to a spanky new Windows 2008 64-bit effort. The app uses Jet Ole DB 4.0 to read uploaded Excel spreadsheets and move the contents to our database.

I checked c:\window\SysWoW64 and there they are msjetoledb40.dll msjet40.dll etc, so Jet 4.0. Odd. It turns out that IIS7 disables 32-bit applications by default, you need to enable them through the app-pool settings. Instructions (and where I got the solution from!) here:
nkadesign blog windows 2008 the microsoftjetoledb40 provider is not registered on the localmachine/[^]

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
United Kingdom United Kingdom
I Graduated in Natural Sciences (Chemistry & Physics) from Durham University, where I did not cover myself with glory, but did fill, and often cover, myself with beer.

I qualified as a secondary school teacher, but I hated teaching. I worked as an IT techhie for a few years but kept being promoted to IT Trainer, thanks to my teaching experience, which I also disliked. I spent some time working out what else I could do instead and reduced beer intake.

I realised that I should work as a programmer, having enjoyed it a hobby since I was a nipper in the halcyon days of the Sinclair Spectrum (48k, Rubber Keyboard). Spent two weeks working out why I didn't think of this to start with, instead of starting my dull-as-ditch-water Chemistry degree 8 years earlier. Had a beer to celebrate.

I Graduated in 2001 with an MSc from Newcastle Uni in Comp Sci. Did cover myself with glory, and drank some beer.

.Netting ever since, and loving it. Though I have largely given up beer due to not being able to hack the pace like I used to.

I was born, brought up, and have lived most of my life near Newcastle. In a fit of temporary insanity I moved to Amman, in my wife's homeland of Jordan, but made it back safely to the UK without any extra holes being made in my person by bullets. To be fair it was pretty safe at the time, if you ignored the roads.

Visit Jordan if you can by the way, the landscape is beautiful and varied, the food excellent and the people the friendliest on earth, after Geordies naturally Smile | :) .

Comments and Discussions

 
GeneralThanks! That problem bit me, too. Pin
Dr.Walt Fair, PE9-Aug-11 9:37
professionalDr.Walt Fair, PE9-Aug-11 9:37 
GeneralReason for my vote of 5 Finally search is over! Thanks. Pin
Muneeb R. Baig8-Aug-11 18:07
Muneeb R. Baig8-Aug-11 18:07 
Reason for my vote of 5
Finally search is over! Thanks.

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.