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

[Database Administrator]

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/pro.../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

[Database Administrator]

can you describe your env. and connection string?
do you have 2 separate servers or all in 1? (1 SSAS, 1 web)
do you use windows authentication? or Basic?
what is the connection string used?
does the web site is in your local intranet list or trusted list? (in IE)

"Arun" wrote in message
news:1174042554.665396.283190@n59g2000hsh.googlegr oups.com...
> 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/pro.../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
>

[Database Administrator]

On 16 Mar, 23:24, "Jeje" wrote:
> can you describe your env. and connection string?
> do you have 2 separate servers or all in 1? (1 SSAS, 1 web)
> do you use windows authentication? or Basic?
> what is the connection string used?
> does the web site is in your local intranet list or trusted list? (in IE)
>
> "Arun" wrote in message
>
> news:1174042554.665396.283190@n59g2000hsh.googlegr oups.com...
>
>
>
> > 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/pro.../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- Hide quoted text -
>
> - Show quoted text -

Solution:
-------------
Thanks for the help offered.

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.