MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Excel gets data using dbo file

  Asked By: Fredrick    Date: Feb 08    Category: MOSS    Views: 2990

I have the book Inside Microsoft Office SharePoint server 2007.Iam trying to follow the Walkthrough:Creating A Dashboard Page.
I have the files: Top10ProductsSubCategories.xlsx and AdventureWorks.dbo
I have a TeamSite so I added a ReportCenter site to it.Then add its DataConnections Library to Trusted Data Connections.Then add the Reports Library to Trusted Files.Then upload the dbo file to the DataConnections Library then open the Excel file Top10ProductsSubCategories.xlsx and add the dbo file to its WorkBook Connections.Then I get the error:No connection could be made because the target machine actively refused it. .
When I close it another error appear:Errors in OLEDB provider.An error occured while loading the connection dialog box component for prompting

I have the SQL 2005 AdventureWorks database already installed.Should I made my own dbo file?If so should I use the option "From SQL Server" or "From Analysis Services" option in Excel Data menu?

Please help me to sove this problem and in which way should I go?

If anything not clear in my question please notify me to explain it.



1 Answer Found

Answer #1    Answered By: Perla Vang     Answered On: Feb 08

At last it works..The Virtual machine I was using didn't has SQL Analysis Services installed correctly.I used another Virtual Machine and use a better installation file  for AdventureWorks Database and make sure that SQL Analysis service is started and every thing after it works fine...

Didn't find what you were looking for? Find more on Excel gets data using dbo file Or get search suggestion and latest updates.