The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine on server 2008 64x

Question

My problem is, i have the site in which .CSV file is uploaded and then read on the server.

But my server is not reading this file instead it throws me the error

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

But it runs fine when i debug from local PC. I tried to install many drivers on my server as specified over here :-

and many more threads but still i m there.

Please help me if any one can!!!

Thanks

BHAVIK GOYAL

Pleun Pleun · Accepted Answer · 2011-02-22T08:33:16

You have to enable the application pool in iis for 32bit applications.

Update: If you only want to read CSV files, I can advise you to use a CSV reader instead of Jet because it is much faster (have a look at http://www.codeproject.com/KB/database/CsvReader.aspx)