Microsoft.ACE.OLEDB.12.0 provider not registered on local Machine

  • My source file was created in Excel 2007, so i had to install ACE drivers on server (I did it before in windows server 2003 but never had any issues), but now after installing ACE drivers i m getting following message when i debug the SSIS

    The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local Machine

    Retry using same user Id and password

    Retry using new user Id and password

    I installed ACE driver on windows server 2008

  • Where are you executing the package?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • I am executing package from the server where ACE drivers are installed

  • Not sure, but this may be a 32/64-bit issue. Can you try running the package in 32-bit mode and see whether that helps?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Ran package under 32 bit mode, didn't work....Any other suggestions???

  • From the reading I've done, there are a number of different scenarios that can lead to this message. I've found the following article to be helpful: MSDN Social: HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine[/url]. It may or may not be helpful for your situation. The author addresses one approach to fixing the error. Several other approaches are discussed in the lengthy comments section.

  • see if this link helps you - Microsoft OLE DB 12.0 Provider Not Registered

    :rolleyes:

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply