none
PowerPivot v2: Access provider not installed

    Question

  • I just upgraded to the new Powerpivot v2.  I am trying to get data from an access 2003 database.  When I specify the database and click "Test Connection" I get the following error:

    ============================
    Error Message:
    ============================

    Cannot connect to the data source because the Access provider is not installed.

    ============================
    Call Stack:
    ============================

       at Microsoft.AnalysisServices.Common.DataSourceBasic.ValidateProviderInformation()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

    ============================

    I can successfully load and refresh Excel data but I cannot connect to either Access 2003 or Access 2010 databases.  I have Office 2010 32 bit and it is fully patched.  I even installed the Access Data Engine 2010 thinking it would help but no.

    Any ideas how to troubleshoot this?  Do I need to revert to Powerpivot v1?


    cnuk

    Friday, April 06, 2012 10:13 PM

Answers

All replies