Post reply

Errors when connecting to a cube with Excel

  • July 2, 2007 at 12:40 pm

    #124892

    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

    #719220

    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

    #719508

    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