July 2, 2007 at 12:40 pm
I was wondering if anyone is familiar with connecting to cubes through Excel 2007. I am able to see the cube, but when I reach the part where the data is supposed to be imported, I am getting the following errors:
"An error has occured in teh transport layer."
"Errors in the OLE DB provider. An error occurred while loading the connection dialog box components for promting."
I think that the issue is not with the cubes. All my reports in Reporting Services are working just fine. Thank you for any help!
Thanks,
- John M.
July 13, 2007 at 3:23 am
I would reinstall Analysis Services 9.0 OLEDB Provider, this is available as a seperate install from the MS download site.
good luck
July 15, 2007 at 1:15 am
I tried reinstalling it with no luck. However, I ran the Microsoft Office Diagnostic Tool which notified it found and fixed 1 issue (without telling me what it fixed) and it now seems to be working. As much time as I put into this, I am glad it turned out to be a simple fix. Thank you for the help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply