dbTalk Databases Forums  

I need some help with Microsoft SqlServer Analysis Services 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss I need some help with Microsoft SqlServer Analysis Services 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
NATE
 
Posts: n/a

Default I need some help with Microsoft SqlServer Analysis Services 2005 - 01-05-2006 , 03:31 PM






I need to display the information of a cube in a web page.
I 've found the CellSetGrid control but I can't connect this component
to the cube
I've used the connectionstring : "Provider=MSOLAP.2;Password=xxxx;User
ID=xxxx;Data Source=localhost;Initial Catalog=Cubo2; ConnectTo=9.0;"
I have the Microsoft Analysis Services Server running in my local
machine with the database and the cubes


Reply With Quote
  #2  
Old   
Raman Iyer [MS]
 
Posts: n/a

Default Re: I need some help with Microsoft SqlServer Analysis Services 2005 - 01-05-2006 , 03:51 PM






MSOLAP.2 refers to the AS2k OLE DB provider, which cannot connect to an
AS2005 server. Use MSOLAP.3 instead.

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"NATE" <rfallas (AT) gmail (DOT) com> wrote

Quote:
I need to display the information of a cube in a web page.
I 've found the CellSetGrid control but I can't connect this component
to the cube
I've used the connectionstring : "Provider=MSOLAP.2;Password=xxxx;User
ID=xxxx;Data Source=localhost;Initial Catalog=Cubo2; ConnectTo=9.0;"
I have the Microsoft Analysis Services Server running in my local
machine with the database and the cubes




Reply With Quote
  #3  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: I need some help with Microsoft SqlServer Analysis Services 2005 - 01-05-2006 , 03:57 PM



Hi

What CellSetGrid control do you mean?

Thanks,
Vladimir Chtepa

"NATE" <rfallas (AT) gmail (DOT) com> wrote

Quote:
I need to display the information of a cube in a web page.
I 've found the CellSetGrid control but I can't connect this component
to the cube
I've used the connectionstring : "Provider=MSOLAP.2;Password=xxxx;User
ID=xxxx;Data Source=localhost;Initial Catalog=Cubo2; ConnectTo=9.0;"
I have the Microsoft Analysis Services Server running in my local
machine with the database and the cubes




Reply With Quote
  #4  
Old   
eminio
 
Posts: n/a

Default Re: I need some help with Microsoft SqlServer Analysis Services 20 - 03-03-2006 , 05:59 AM



I have a connection established and it is retrieving data from cube, which is
good,but it does not show anything good on the screen, although I made
changes in DOCTYPE definition as suggested in groups.google.com

I can't find source file anywhere to fix and play with these control,can
anyone help me please. Setup files from
http://www.sqlserveranalysisservices...tGridIntro.htm
don't install source files on my laptop.

Waiting for your help,
Eminio
"Raman Iyer [MS]" wrote:

Quote:
MSOLAP.2 refers to the AS2k OLE DB provider, which cannot connect to an
AS2005 server. Use MSOLAP.3 instead.

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"NATE" <rfallas (AT) gmail (DOT) com> wrote in message
news:1136496668.039684.12350 (AT) f14g2000cwb (DOT) googlegroups.com...
I need to display the information of a cube in a web page.
I 've found the CellSetGrid control but I can't connect this component
to the cube
I've used the connectionstring : "Provider=MSOLAP.2;Password=xxxx;User
ID=xxxx;Data Source=localhost;Initial Catalog=Cubo2; ConnectTo=9.0;"
I have the Microsoft Analysis Services Server running in my local
machine with the database and the cubes





Reply With Quote
  #5  
Old   
necati@cbksoft
 
Posts: n/a

Default Re: I need some help with Microsoft SqlServer Analysis Services 20 - 04-07-2006 , 08:31 AM



if you mean, you want to create a dataTable by using MDX queries,

The following page includes an example with vb.net
it may be helpful to you..

http://www.aspfree.com/c/a/MS-SQL-Se...ASP-dot-NET/3/

--
Necati Sekkeli
CBKSoft
Junior Software Developer


"Vladimir Chtepa" wrote:

Quote:
Hi

What CellSetGrid control do you mean?

Thanks,
Vladimir Chtepa

"NATE" <rfallas (AT) gmail (DOT) com> wrote in message
news:1136496668.039684.12350 (AT) f14g2000cwb (DOT) googlegroups.com...
I need to display the information of a cube in a web page.
I 've found the CellSetGrid control but I can't connect this component
to the cube
I've used the connectionstring : "Provider=MSOLAP.2;Password=xxxx;User
ID=xxxx;Data Source=localhost;Initial Catalog=Cubo2; ConnectTo=9.0;"
I have the Microsoft Analysis Services Server running in my local
machine with the database and the cubes





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.