0

I have created an ASP.net web application which reads data from excel sheet and displays it in jquery data table.

After taking a build and deploying it on IIS 8, it works fine on my machine. But once I deploy it on another machine which has 32 bit office installed, there is Microsoft.OLEDB 12.0 driver not registered error.

But even after installing microsoft redistriuable and data connectivity components I am getting the same exception.

Every answer on stackoverflow covers driver installation but it dosen't help in my case.

Aristos
  • 66,005
  • 16
  • 114
  • 150
Batman Rises
  • 319
  • 2
  • 5
  • 14
  • Please make a better question, some code, reference what you have try - there are many answer for this issue on google... – Aristos Oct 17 '16 at 21:28
  • also : http://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine – Aristos Oct 17 '16 at 21:29
  • @Aristos there is no code apart from excel connection string...also can you please tell what you are not able to understand from the question ? – Batman Rises Oct 18 '16 at 15:50
  • @Aristos I have already mentioned I have tried installing drivers mentioned in the link you have given..so your answer dosent help me.Thanks! – Batman Rises Oct 18 '16 at 15:53
  • @Aristos further i have check whether there is 32bit oledb driver If 32bit is installed "ACEOLEDB.DLL" should exists here : C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL – Batman Rises Oct 18 '16 at 16:18
  • @Aristos why did you marked question as duplicate ? There are other problems related to this question which was done after following this link http://www.aspsnippets.com/Articles/IIS-7-and-IIS-8-Enable-32-bit-Applications-in-Application-Pool-of-IIS-Server.aspx – Batman Rises Oct 18 '16 at 16:54
  • There are people who might be looking for this solution so please remove duplicate mark – Batman Rises Oct 18 '16 at 16:54
  • Your question is very bad formatted and very poor in information's. If you make a better question and show what you have try, more details about error etc... and the error message is the same... and a lot of answers in internet - show what you have try and fail, what is the different in you ? Even if the question opens again, you get no answer-help as it is. – Aristos Oct 18 '16 at 17:01
  • @Aristos I think my question is extremely good and within few days i will try to add step by step things of what i have done to solve this issue.Other users might find answer to this question helpful.,.I will edit it and its not duplicate for sure – Batman Rises Oct 18 '16 at 17:13
  • http://www.aspsnippets.com/Articles/IIS-7-and-IIS-8-Enable-32-bit-Applications-in-Application-Pool-of-IIS-Server.aspx... This link is the solution for above question. for 32 bit applications on IIS we need to enable it explicitly. – Batman Rises Oct 20 '16 at 17:17
  • @Aristos do you still think question needs to be edited.I tried my best to edit the question according to standards. – Batman Rises Oct 20 '16 at 17:19
  • Ok I reopen it and see what is happends – Aristos Oct 21 '16 at 06:38

0 Answers0