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

8 posts, 1 answers
  1. Alan
    Alan avatar
    6 posts
    Member since:
    Aug 2011

    Posted 22 Aug 2013 Link to this post

    Hello,

    We are having mixed results with being able to execute tests on a remote machine.  Some are able to run successfully while others produce this error message.  Has anyone come across this message?  Searches on Microsoft point to a version of Access Data Connectivity Components needing to be installed.  Microsoft Office is not installed on the remote machine.  How can certain tests run and others not?  Do we actually need to install the Data Connectivity Components?

    Thanks...


    Edit--more info...

    The project that is successfully running has data bindings to an Excel 2003 workbook.
    The projects that aren't successfully running have Excel 2007 workbooks.
    I've tried saving the Excel 2007 workbooks as Excel 2003 workbooks, redoing the data-binding, but that still did not work.
    I can successfully have both projects run on my local machine which has Office 2007 installed.
  2. Answer
    Cody
    Admin
    Cody avatar
    3354 posts

    Posted 22 Aug 2013 Link to this post

    Hello Alan,

    We have this troubleshooting article that addresses this problem:
    http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/troubleshooting_guide/test-execution-problems/unable-to-show-the-data.aspx

    Regards,
    Cody
    Telerik
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  3. Alan
    Alan avatar
    6 posts
    Member since:
    Aug 2011

    Posted 23 Aug 2013 Link to this post

    My fault, I remember searching for Microsoft.ACE.OLEDB.12.0 in your User Guide and receieved two results.  The first result didn't apply to my situation and I didn't check the second result, and of course this is the second result.

    Thank you!
  4. Cody
    Admin
    Cody avatar
    3354 posts

    Posted 23 Aug 2013 Link to this post

    Hello Alan,

    Thank you for the update, and glad I could help.

    Regards,
    Cody
    Telerik
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  5. Siva
    Siva avatar
    28 posts
    Member since:
    Apr 2012

    Posted 05 Jan 2015 in reply to Cody Link to this post

    I Have the Same issue , My Test refere the data from Excel file Excel Version MS Office 2013

    Using .Net Runtime version: '4.0.30319.34014' for test execution. Build version is '2012.2.1420.0'.
    Starting execution....
     Detected a Silverlight Test. Setting EnableSilverlight=True
     Failure detected during execution. Details:
    ------------------------------------------------------------

    - System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
  6. Cody
    Admin
    Cody avatar
    3354 posts

    Posted 05 Jan 2015 Link to this post

    Hi Siva,

    We have recently moved our documentation to a new home. Here is the new link. To fix the problem you're running into simply install the 2007 Office System Driver: Data Connectivity Components.


    Regards,
    Cody
    Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  7. Matthew
    Matthew avatar
    4 posts
    Member since:
    Feb 2017

    Posted 19 Jun Link to this post

    Just wanted to provide a quick note for anyone that encounters this:

    I used Cody's link in the above post and installed the 64 bit version of Microsoft Access Database Engine 2010, which did not work.

    Note that Telerik's documentation states, "This (the problem) could be observed also if the Microsoft Office package is 64-bit version." The 32 bit version must be installed for this error to be resolved.

  8. Elena
    Admin
    Elena avatar
    1104 posts

    Posted 20 Jun Link to this post

    Hi Matthew,

    Thanks very much for the mentioned note - it is completely valid and I will take care the information listed in the article on the topic to be organized better. 

    Regards,
    Elena Tsvetkova
    Progress Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
Back to Top