The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Scenario: You are a web server administrator and you got a web site or an application given by developer which is working fine on the developer machine now you have hosted the web site on the Web Server IIS 7 or IIS 8 and its working fine but a little while later a developer call to you and says he is unable to upload the excel files.
See the comprehensive Video Tutorial on YouTube to solve this problem: https://www.youtube.com/watch?v=m4BwtCjs3z8
Error 1: Access to the path 'C:\inetpub\wwwroot\OLEDB-TEST-SITE\UploadedExcel\24032013_013545.xls' is denied.
This error comes because the folder where the file is uploaded doesn't have a write permission to solve this give the IIS_IUSRS write permission on the folder where the files are uploaded. Error 2:
When uploading .xls file your getting this error ( The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
To solve this problem you have to download and install "2007 Office System Driver: Data Connectivity Components" on the web server the link is given at the bottom to this blog.
Also you have to "Enable 32-bit Applications to True" in IIS Application Pool for the web application if you want to upload the .xls files.
See the comprehensive Video Tutorial on YouTube to solve this problem: https://www.youtube.com/watch?v=m4BwtCjs3z8
Error 3:
When uploading .xlsx file your getting this error ( The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. )
To solve this problem you have to download and install "Microsoft Access Database Engine 2010" on the web server the link is given at the bottom to this blog.
Link to Download:-
Microsoft Access Database Engine 2010
http://www.microsoft.com/en-us/download/details.aspx?id=13255
2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/en-us/download/details.aspx?id=23734
Also you can download the test web application to test the OLEDB provider is registered on the local machine or not.
https://docs.google.com/file/d/0B8J5QeSXwQfbVlFiX3YxZXZyS3M/edit?usp=sharing
See the comprehensive Video Tutorial on YouTube to solve this problem: https://www.youtube.com/watch?v=m4BwtCjs3z8
HI there, ~(｡◕‿◠｡)~
= If You Like This Video, Give It a Thumbs Up :)
= Subscribe to receive email updates when we post new videos ;) ,
= Share it with your technical IT friends "_" ,
= if your facing? any technical problem or have any suggestion post your comment here or catch me on google+ or Gtalk :D!
