MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Excel gets data using dbo file

  Asked By: Nakul    Date: Apr 12    Category: MOSS    Views: 1924

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?



No Answers Found. Be the First, To Post Answer.

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