locked
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine RRS feed

  • Question

  • The webserver has reinstalled today, it used to be window 2003 32bit, now it's windows 2003 64bit, when i published the web application on the server, i got this error.

     

    The web applicaiton need to import data from excel.

     

    As it's a web application, i can't change the target cpu to x86 in the advanced compiler options.

     

    How can I fix it?

    Thursday, June 5, 2008 1:47 PM

Answers

  • Now I cannot find the 64bit version on MSDN. For a workaround, you could run it as WOW64 mode, what is the mode 32bit applications are run on 64bit machines.

     

    If you could not change the target cpu to x86, probably you mean that you're using ASP.Net. Because it is built as IL and architecture independent, you could not set the target cpu to it. However, you could run IIS in 32bit mode. For information about how to switch between the 32-bit versions of ASP.NET 1.1 and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Windows, you could visit http://support.microsoft.com/kb/894435/en-us

     

    Thursday, June 5, 2008 1:54 PM
  • I don't know what you mean by that but you can run IIS6 in 32bits mode because if you don't do that your code will not run because there is no 64bits runtime for Office any version.


    http://blogs.technet.com/mbaher/archive/2006/12/17/running-iis-32-bit-applications-on-iis-64-bit.aspx

     

    Thursday, June 5, 2008 1:59 PM

All replies

  • Now I cannot find the 64bit version on MSDN. For a workaround, you could run it as WOW64 mode, what is the mode 32bit applications are run on 64bit machines.

     

    If you could not change the target cpu to x86, probably you mean that you're using ASP.Net. Because it is built as IL and architecture independent, you could not set the target cpu to it. However, you could run IIS in 32bit mode. For information about how to switch between the 32-bit versions of ASP.NET 1.1 and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Windows, you could visit http://support.microsoft.com/kb/894435/en-us

     

    Thursday, June 5, 2008 1:54 PM
  • I don't know what you mean by that but you can run IIS6 in 32bits mode because if you don't do that your code will not run because there is no 64bits runtime for Office any version.


    http://blogs.technet.com/mbaher/archive/2006/12/17/running-iis-32-bit-applications-on-iis-64-bit.aspx

     

    Thursday, June 5, 2008 1:59 PM