Windows 2008: The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine.
Tuesday, October 28, 2008
There are times when the coexistence of 64 and 32 bit code on the same machine can cause all sorts of seemingly strange issues.
One of them just occurred to me while trying to run the ASPx demos from Developer Express, my main provider of .Net components (the best supplier I’ve ever been able to find).
I was getting the following error:
The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine:
It may look otherwise, but this error is generally due to either of two thing:
- you don’t have Office 2007 Jet drivers installed
- or you are running a 32 bit application in a default x64 environment.
The first issue is easy to solve, just download the 2007 Office System Driver from Microsoft.
For the second one, the fix under Windows Server 2008 is easy enough:
Navigate to Server Manager > Roles > Web Server (IIS) > Internet Information Services (IIS) Manager, then look under your machine name > Application Pool.
Under there you can call the DefaultAppPool’s advanced settings to change Enable 32-Bits Applications to True:
You may have to restart the service for it to take effect but it should work.
Entry Filed under : .Net, Database, Programming, Web, sysadmin
4 Comments Add your own
1. finklad | November 14th, 2008 at 6:02 am
Bingo
Thnka god someone knows what they’re talking about.
Additionaly, you will have to set the folder permissions to allow iis_iusrs to connect to the databse from a client pc
2. Abhishek Browne | November 22nd, 2008 at 3:18 pm
I am using Vista 64 bit. Second soln. worked for me
3. Paul | December 4th, 2008 at 7:55 pm
Can you tell me how to navigate to those screens to set the Enable 32-Bits Applications to True on a windows Vista OS?
4. Renaud | December 8th, 2008 at 3:02 pm
@Paul: you should be able to access IIS configuration settings by right-clicking on My Computer and choosing Manage to open the Computer Management console.
From there, IIS settings are accessible under the Services and Applications tree.
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed