Tuesday, December 4, 2007

How to connect to the Analysis Server through the use of URL

How to connect to the Analysis Server through the use of URL

Connect to the Analysis Server through the use of URL

Here’s how the code does it.

Dim cat as new ADOMD.Catalog

cat.ActiveConnection = "Provider = msolap;" & _

" Datasource =" _ &

" http://www.microsoft.com/;" & _

" Initial Catalog = FoodMart 2000"

No comments: