I have an issue with connecting Excel to an analysis Services 2005 database. The computer is running Windows XP Sp2 and Office XP. I installed the oledb driver 9.0 but when I tried to connect with the pivot table and I want to create the connection, the dropdown list of the data provider is empty. I tried on another computer with Excel XP and the system is working fine.
Is there somebody that could help?
Thank you
It sounds like it might be a connection/networking issue? On the computer, try making an ODBC Data Source. You can do this by choosing Start->Control Panel->Administrative Tools->Data Sources (ODBC).
From here, on the User DSN tab, press the Add... button. On the list of providers, you should see "SQL Native Client" or "SQL Server". Choose one of these. On the next dialog, you should see 3 fields, Name, Description, and Server. Use the drop down list of "Server" to see if you can find the server that you're looking for. If you can, then it's something else. If you can't, then talk to your system administrator about troubleshooting why that server can't be seen from your computer. Either way, you can cancel and close these dialogs without making any changes to your computer. This should only test the visibility of the server to your computer.
Hope this helps. Please follow up if this doesn't help you.
|||
Thanks for the help but it doesn't work. If I try to create an ODBC connection the system is working fine. It seems to me that the problem is related only to the OleDb component for Analysis Services. I am going to try to uninstall and install back office to see it this will fix something.
Thanks again!
No comments:
Post a Comment