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.