Hi,

I was looking for a sample that demonstrates use of OWC - Pivotable that use
Msolap.asp to fetch data from Analysis Services.

Regards

mangesh

There is nothing special from OWC for accessing data over HTTP (which is
what msolap.asp is there for).

All you do is specify a server name of http://serverort rather than
"server" -- the leading http:// characters tell PTS that it should make a
connection via HTTP to the server (port defaults to 80 if not specified)
rather than normal client-server (port 2725).

However, there are some setups you need to do to enable msolap.asp -- see
BOL.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Mangesh Pawar" <p.mangesh (AT) zensar (DOT) com> wrote