SQL Analysis Services Microsoft ACE OLEDB provider is not displayed RRS feed

  • Question

  • I working on an SQL Analysis Services school project and my given database is an access database .mdb file when I trying to make a new data source for access file I can only see Microsoft.Jet.OLEDB.4.0 driver though I have already installed following drivers:

    • MS Office 2016 Microsoft.ACE.OLEDB.12.0
    • Microsoft.ACE.OLEDB.15.0
    • Microsoft.ACE.OLEDB.16.

    I have been searching for a solution to use other providers, could not find any. So, I'm using Microsoft.Jet.OLEDB.4.0 on my project, but I'm following error:

    Errors in the back-end database access module. the provider 'Microsoft.Jet.OLEDB.4.0' is not registered.

    The problem is I'm unable to get list of providers other than Microsoft.Jet.OLEDB.4.0, and if I use that getting error (as per above screenshot). Can anyone advise fix for this problem.

    • Moved by Dave PatrickMVP Saturday, November 7, 2020 12:48 PM looking for forum
    Saturday, November 7, 2020 11:19 AM


All replies