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

Question

I had developed a web application using Visual Studio 2010 which one of the function is to import Excel file(.xls).However when I deployed the web application over the Server(Windows Server 2003 - IIS version 6) the following error will occurred:

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

This problem doesn't exists when I deployed it in Windows 7(IIS version 7).

Please advice me regarding how to solve this problem.Thanks.

Answer 1

If your application runs in 64bit mode, change it to run in 32bit mode. There is no 64bit version of jet AFAIK.
http://connect.microsoft.com/VisualStudio/feedback/details/123311/win-xp-x64-jet-v4-0

Answer 2

I'm currently using the Visual Studio 2010 to develop the web application, but the platform available is Any CPU only,there is no x86.

Answer 3

In your application's web.config you can find a <compilers>-entry. Here you can define a new attribute: compilerOptions="/platform:x86".

/platform (C# Compiler Options):
http://msdn.microsoft.com/en-us/library/zekwfyz4(v=vs.100).aspx

If this still doesn't work for you, check the IIS-installation on the target system: Is the use of 32-bit applications enabled (application pools > yourpool > advanced settings > general)?

Answer 4

In IIS 7.0 you need to change the Enable 32-Bit Applications property (Advanced Settings) to True for the Application Pool the app is running under.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 5

That was one of my yesterday assumptions too.
Without further info, it's hard to tell.

Answer 6

Yeah, sorry about that I kind of glanced at your last response.

I suppose the other possibility is a bad Jet install, although I think it's likely the 32/64-bit issue.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 7

Hello,

the obvious guess is that your Windows 7 is 32bit and your production server is 64bit,
I've got the same problem yesterday, here's how i got the Jet drivers running on a 64bit machine: http://www.codicode.com/art/the_microsoft_jet_oledb_4_0_prov.aspx

hope this helps