I am trying to show Olap cube to either ASP.NET or ASP web page.
What is general Connection String script used?

I searched thru Google and internet, but was not able to find any article
really helpful directly.

Thanks.
Justin

Provider=msolap.2;data source=<server>;initial catalog=<foodmart
2000>;Integrated Security=SSPI;SSPI=Kerberos

put msolap.3 for AS2005 and msolap.2 for AS2000
using only provider=msolap use the default provider (generally the most
recent driver)

SSPI=Kerberos is required when the web server and the OLAP server are on 2
diffrents servers (search for IIS + kerberos keywords on the MS website to
learn more)

if you are not sure about the string, create an excel file, connect it to
your AS server using the pivottable, save as web page, edit the web page
with notepad to see the connection string generated.


"Justin Doh" <JustinDoh (AT) discussions (DOT) microsoft.com> wrote

I am pretty novice when it comes to coding.

I have created olap.asp under my root folder (under 'justin' folder).
Here is a following code.

<%@ LANGUAGE="VBSCRIPT"%>
<%
Dim MyCon as ADODB.Connection
Set MyCon = new ADODB.Connection
MyCon.Open("provider=msolap; Datasource=localhost; Initial Catalog=FoodMart
2000; Connect Timeout=5")
%>


And got this error (see bottom)


Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/justin/olap1.asp, line 25, column 10
Dim MyCon as ADODB.Connection
---------^

Any suggestions?

Appreciated.

Justin


"Jéjé" wrote:

oohh...

ASP is too old for me now ;-)
first, switch to ASPX
there is a free visual studio available to help you to develop your
application.

second, if you don't know how to play with your cube, maybe you have to
focus on existing controls on the market like the snowflake (intellimerce)
product.
The price of a tool will be far less then a custom development!



"Justin Doh" <JustinDoh (AT) discussions (DOT) microsoft.com> wrote

Hi,
Maybe change this: "Datasource"
to this: "Data Source"
?
Ta
Richard

Hi Jéjé,

Do you have any advice how I should write ASP.NET script to display OLAP
cube or pivot table that is generated?

Thank you for any comment.
Justin

"Jéjé" wrote:

sample application:
http://www.sqlserveranalysisservices.com/default.htm

but you can found some samples on the web.
Displaying is not so complex... but if you want to allow the user to play
with the data (like he can in the pivottable) this is another level of work!

"Justin Doh" <JustinDoh (AT) discussions (DOT) microsoft.com> wrote

Thank you so much Jéjé.
I will take a look at the site on Monday.

I am trying to get some sample of code to display Olap cubes using ASP.NET.
Is there any good reference website or publications I could look into?

I would appreciate for any comment.

Thanks.
Justin

"Jéjé" wrote:

Thinslicer has both an ASP and ASP.NET version with source code. You can
use it "as is" or have a look at how it is doing things.

http://richardlees.com.au/Home_files...cerHistory.htm

If you are going to use this app in an intranet, the BI portal sample
app from MS is another approach to look into.

http://www.microsoft.com/downloads/d...3d11925e-1ed6-
43b0-bb94-fe69170ccf82&DisplayLang=en

Mosha has a couple of other thin clients on his page at:

http://www.mosha.com/msolap/util.htm#ThinClients

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <60145469-A6EC-4E22-9976-7657E775C48B (AT) microsoft (DOT) com>,
JustinDoh (AT) discussions (DOT) microsoft.com says...

Hi Jéjé,

I am a little confused... If I am creating my webpage in version 2.0 of the
..NET framework, do I still need Kerberos if my webserver & my AS2000 server
are two different machines?

If so, where do I configure Kerberos? On my webserver? I have IIS on my
AS2000 server as I am currently using XMLA to connect.

I never could get MSOLAP to work. Even if I set up my cube roles to allow
Everyone access. Must have been because I did not configure Kerberos...

Thanks!


Tina





"" wrote: