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

  • Question

  • Hi

    Using Windows Server 2008 R2 64 Bit and Office 2010 64 Bit with Visual Studio 2008.

    I am trying to use a Data Flow Task then a Excel connection to import data, but I get the error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine".

    I have installed the 64 bit driver on  Microsoft Access Database Engine but there is no change. I understand Visual Studio is 32 bit but when I try to install the 32 bit driver, I get a warning. 'you cannot install the 32 bit of the MS Access database Engine 2010 because you currently have 64 bit office products installed etc...."

    The excel connection manager has the ACE.OLEDB.12.0 in it's connection string properties. Then when I go to the Excel source widget and try to select the name of the sheet it says the ACE.OLEDB.12.0 driver is not installed on local machine.

    So is the solution to ignore the warning about the 32 bit office drivers and uninstall the office 64 bit and install the 32 bit drivers then the 64 bit office and drivers again over the top? Will this work or will the 32 bit drivers be removed?

    Or is there another solution?

    Thanks

    Friday, November 30, 2012 3:22 AM

Answers

  • You could try installing the 2007 version of the Microsoft Access Database Engine, which is limited to 32-bit. I've not tested this theory but the VS IDE runs 32-bit so I'm pretty sure the Data Designer would not be able to work with 64-bit database providers or drivers.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Cameronh Sunday, December 2, 2012 11:17 PM
    Friday, November 30, 2012 5:23 PM

All replies

  • Looks like VS 2008 is not compatible with 64 bit drivers and I would have run on 32 bit office to get this to work. Does anyone know if VS 2010, 2010 SP1 runs is compatible with 64 bit drivers ( i can see that 2012 is)?
    Friday, November 30, 2012 4:53 AM
  • You need to compile your app to 64 bits to use 64 bits drivers.

    VS2010 can compile to 64 bits.


    -

    Friday, November 30, 2012 11:36 AM
  • You could try installing the 2007 version of the Microsoft Access Database Engine, which is limited to 32-bit. I've not tested this theory but the VS IDE runs 32-bit so I'm pretty sure the Data Designer would not be able to work with 64-bit database providers or drivers.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Cameronh Sunday, December 2, 2012 11:17 PM
    Friday, November 30, 2012 5:23 PM