none
Resolving error using 2010 Office System Driver Data Connectivity Components

    Domanda

  • I couldn't find an applicable solution to this problem, so once I figure it out, I thought I'd publish my resolution in case it helps anyone else. 

    Scenario: Trying to run a Powershell script on a 64-bit Window 7 machine with 32-bit Office 2010 installed, using the Office 2010 OLEDB provider, get the following error:  "microsoft.ace.oledb.12.0 provider is not registered on the local machine".  

    The issue is that the provider is a 32-bit provider and I was trying to run the script in the 64-bit version of Powershell ISE. To resolve it, I had to run the 32-bit Powershell ISE ("C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell_ise.exe"). 

    martedì 26 giugno 2012 22:32

Risposte

Tutte le risposte

  • This is an issue not just with Powershell, but also many other utilities. A 32-bit database server requires a 32-bit application.

    There's is 64-bit version of the ACE driver. Why not uninstall the 32-version and install the 64-bit version?

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    • Proposto come risposta Tiger Li mercoledì 27 giugno 2012 03:00
    • Contrassegnato come risposta Tiger Li venerdì 29 giugno 2012 02:48
    mercoledì 27 giugno 2012 02:36
  • I tried that, but if you have 32-bit Office installed, the 64-bit ACE driver won't let you install it. It asks you to uninstall Office. So, you can have one or the other, but not both.
    mercoledì 27 giugno 2012 02:56
  • That's correct. Your only option is to use 32-bit ISE or Powershell with the 32-bit ACE Driver.
    mercoledì 27 giugno 2012 11:52
  • This is an issue not just with Powershell, but also many other utilities. A 32-bit database server requires a 32-bit application.

    There's is 64-bit version of the ACE driver. Why not uninstall the 32-version and install the 64-bit version?

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    This is NOT the answer to the question.  I wish mods would stop marking posts as answer.  The only person who can possibly mark something as answered is the person who asked the question.  Behavior like the mods makes TechNet useless because it is full of threads which are marked as answered even though the answers don't pertain the the question asked.

    The OP cannot use the 64-bit ACE version when the 32-bit version of Office is installed.  The 64-bit ACE installer will generate an error pointing out that you cannot install the 64-bit driver with the 32-bit version of office.

    • Modificato The German lunedì 13 agosto 2012 17:42
    lunedì 13 agosto 2012 17:41
  • If you have already installed the x86 version of the Microsoft Access Database Engine 2010 Redistributable from http://www.microsoft.com/en-us/download/details.aspx?id=13255 AND you have run the Powershell ISE (x86) as Administrator and it still doesn't work then install the 2007 Office System Driver: Data Connectivity Components from http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 as well.

    I don't quite understand why but once I installed the 2007 system driver it worked for me even though I am using Office 2010 (32-bit).

    lunedì 13 agosto 2012 17:47