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 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:
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:
Here is my providers list: