Display PivotTable from SQL data in WSS 3
Posted on 2009-12-21
I've installed the Office Web Components (client and server) for WSS 2 on my WSS 3.0 SP1 server (following Microsoft instructions). The install went okay, and I believe the components are working.
I'm now trying to use the PivotTable Web Part to display data from an SQL database (server located on same machine, but I don't think that makes any difference).
I've tried a couple of methods: 1. creating a working .ODC file and storing it in a document library, then liking the Web Part to this. 2. Clicking the 'Connect to external data source' link and creating a new connection using OLEDB for SQL Server.
Both methods return the same error: 'There was an error while retrieving data from the data source."
I'm not even sure if what I want to do is possible in WSS 3 -- I'm really after confirmation whether this should work or whether to stop trying.