dbTalk Databases Forums  

Olap actions over http

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


Discuss Olap actions over http in the microsoft.public.sqlserver.olap forum.



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

Default Olap actions over http - 04-16-2004 , 08:14 AM







Has anyone tried to use olap actions with an http connection to AS ?

I use actions extensively to launch context sensitive reports and it works
perfectly with a normal connection ... but the OpenSchema statement doesn't
return any records when the connection is http. Is it supported over http ?

adors = element.Connection.OpenSchema(-1, sarrRestrictions,
"{A07CCD08-8148-11D0-87BB-00C04FC33942}");

I also tried:
adors = element.Connection.OpenSchema(adSchemaActions_c,sa rrRestrictions);



Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: Olap actions over http - 04-19-2004 , 05:24 AM






Hi Richard,

Does your configuration has:

HTTP connections work only with the Enterprise Edition of Analysis Services.
Internet Information Server (IIS) has to run on the computer where Analysis
Services is running. Although IIS has to be running on the computer where
Analysis Services is running, IIS does not need to be your hosting Web
server. For example, you can connect to IIS that is running on computer A
while Analysis Services runs on computer B. However, IIS also needs to be
running on computer B.
The client must have the OLE DB Provider for OLAP version 8.0 installed.
You can install the Analysis Services Client Components by running the
Ptsfull.exe program on the client from the SQL Server 2000 CD.

If yes check the following references:

Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to
Connect to Analysis Services over the Internet
ID: 324961.KB.EN-US
http://support.microsoft.com/default...b;en-us;324961

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."


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.