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/[
^]
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
.