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

When i am trying to populate a html table by importing data from an excel template i am encountering this error.

any help would be appreciated....

p.s. i have installed the MS Office package in the system from which i am accessing the application(i.e. Server).

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

Have you tried any of these suggestions found on this post?

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/45aa44dd-0e6f-42e5-a9d6-9be5c5c8fcd1/

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

Thanx for the reply but the machine in which my application is installed is a server machine(running on Windows Server 2008 R2 SP1) and it is as u can guess running on the 64-bit OS.

so i am lost a bit, there were so many replies in the link that you suggested i had tried some of them before, some i tried but in vain.so do let me know if you hava any more ides....

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

bloggernext
the machine in which my application is installed is a server machine(running on Windows Server 2008 R2 SP1) and it is as u can guess running on the 64-bit OS.

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 DefaultAppPools 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

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

Microsoft.Jet.OLEDB.4.0 is supported on Windows 2008 R2 SP1 64bit without the need to install anything.

Application pool must be configured with 32 bit application enabled though.

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

I appreciate the answers given above but in vain, i am still facing the same issue regarding The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

I have configured the Application pool with 32-bit application to be enabled.please let me know how to proceed.