I'm have been trying to get access to Analysis Services via HTTP.
I installed MS XP office component on my machine. Then I copied msolap.asp
into a web root.
When I point my browser to this file -nothing happens just one <html> tag.
Anyways I don't get any errors. Then I try to get access to OLAP from a
Pivot table on a HTML page.
If i write
PTable.ConnectionString = "provider=msolap;data source=myserver;inital
it works - but I need http!
PTable.ConnectionString = "Provider = msolap; data source
=http://MY_IP_HERE/olap/msolap.asp; Initial Catalog = FoodMart 2000"
- it doesn't work.
I keep trying an example from the msdn like
Dim cat as new ADOMD.Catalog
cat.ActiveConnection = "Provider = msolap;" & _
" Datasource =" _ &
" http://<URL>/;" & _
" Initial Catalog = FoodMart 2000"
It doesn't work (error - object not found). Obviosly - something wrong with
the .asp page.
Is there anyone who was successfull with this magic msolap.asp
I have an Interprise edition SQL2000.