OWC 11 - SSAS 2005 (sp1) from ASP .Net (VS 2005) deployed on IIS 5.1

[arun.ns]

Hello,

I have a cube deployed in SSAS 2005 (sp1) in my local machine (Windows
XP prof sp2).

I have set up http access using http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx.
The connection string "http://localhost/olap/msmdpump.dll" works fine
with Excel and the pivot table fetches data.

When I try to use OWC 11 in a ASP .Net webpage and deploy in my local
machine, the pivot table returns the following error.

"The query could not be processed : The data provider didn't supply
any
further error information."

Any help is appreciated.

Cheers,
Arun

 

[arun.ns]

On 16 Mar, 10:53, (e-mail address removed) wrote:

Solution:
-------------
This is now sorted out. The problem was with the connection string. I
sorted out by establishing connection using OWC in forms app and
copying the connection string to the web app.

My SSAS and IIS are on different servers and I use Windows
authentication.