You are here

Errors in the ole db provider

Submitted by Asif Nowaj, Last Modified on 2019-11-22

I have encountered this below error while I was trying to connect SQL Server Analysis Services cube using Microsoft Excel 2010.
Errors in the ole db provider: an error occurred while loading the connection dialog box component for prompting.
I remember it was working fine couple of month ago.
Now, this is how I have resolved the issue by re installing SQL server 2008 AS OLEDB drivers:
1. Go to https://www.microsoft.com/en-us/download/details.aspx?id=6375
2. Click “Download”
3. Find “SQLSERVER2008_ASOLEDB10.msi” in the list of file name
4. Tick the Checkbox
5. Press “Next”
6. It will automatically download the setup file
7. Installed it [Remember to close the excel file or any program that is accessing OLE DB driver]

Discussion or Comment

If you have anything in mind to share, please bring it in the discussion forum here.

https://forum.everyething.com/others-f41/