dbTalk Databases Forums  

XMLA .Net Sample doesn´t workkk

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


Discuss XMLA .Net Sample doesn´t workkk in the microsoft.public.sqlserver.olap forum.



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

Default XMLA .Net Sample doesn´t workkk - 06-18-2004 , 05:43 AM






Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the datasource.xml file, as follow:
<DataSource>
<DataSourceName>FoodMart 2000</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=md001144</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

Then i created a Virtual Directory as mentioned in the sdk help
but when i try to connect using the Sample.Net included in the sdk,
the application shows a Message Box: "No Catalog Found at this session"

In the Analysis Server i have two servers running:
mdsqlserver
and
md001144 (local) in which i have the FoorMart 2000 Sample (the one i want to access)
Do You Have Any Suggestions??? Thanks!

Reply With Quote
  #2  
Old   
Jose Mariano Alvarez \(MUG\)
 
Posts: n/a

Default Re: XMLA .Net Sample doesn´t workkk - 06-18-2004 , 01:19 PM






Make sure you have in IIS the anonymous logon checked.

If md001144 is a local database, then you can change the datasource.xml
file, as follow

<DataSourceInfo>
Provider=MSOLAP.2;Data Source=local
</DataSourceInfo>

--
Jose Mariano Alvarez
Comunidad de base de datos
Grupo de Usuarios Microsoft
www.mug.org.ar



"Juan" <Juan (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the
datasource.xml file, as follow:
DataSource
DataSourceName>FoodMart 2000</DataSourceName
DataSourceDescription>Microsoft Analysis Server 2000 on local
machine</DataSourceDescription
URL>http://localhost/xmla/msxisapi.dll</URL
DataSourceInfo>Provider=MSOLAP.2;Data Source=md001144</DataSourceInfo
ProviderName>Microsoft XML for Analysis</ProviderName
ProviderType
TDP/
MDP/
DMP/
/ProviderType
AuthenticationMode>Unauthenticated</AuthenticationMode
/DataSource

Then i created a Virtual Directory as mentioned in the sdk help
but when i try to connect using the Sample.Net included in the sdk,
the application shows a Message Box: "No Catalog Found at this session"

In the Analysis Server i have two servers running:
mdsqlserver
and
md001144 (local) in which i have the FoorMart 2000 Sample (the one i want
to access)
Do You Have Any Suggestions??? Thanks!



Reply With Quote
  #3  
Old   
Marco Groeneveld
 
Posts: n/a

Default Re: XMLA .Net Sample doesn´t workkk - 06-18-2004 , 02:38 PM



Hi,

I have a feeling you changed the wrong lines. http://localhost
shouldbe your server and data source local.

Visit also www.reportportal.com, download the free 90-day trail of
reportportal and be productive within 15 minutes. Watch also the
installation screendump video what, where to change to have XMLA +
ReportingPortal working within 15 minutes.

Regards, Marco

www.gmsbv.nl

"Juan" <Juan (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the datasource.xml file, as follow:
DataSource
<DataSourceName>FoodMart 2000</DataSourceName
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription
<URL>http://localhost/xmla/msxisapi.dll</URL
<DataSourceInfo>Provider=MSOLAP.2;Data Source=md001144</DataSourceInfo
<ProviderName>Microsoft XML for Analysis</ProviderName
<ProviderType
<TDP/
<MDP/
<DMP/
</ProviderType
<AuthenticationMode>Unauthenticated</AuthenticationMode
/DataSource

Then i created a Virtual Directory as mentioned in the sdk help
but when i try to connect using the Sample.Net included in the sdk,
the application shows a Message Box: "No Catalog Found at this session"

In the Analysis Server i have two servers running:
mdsqlserver
and
md001144 (local) in which i have the FoorMart 2000 Sample (the one i want to access)
Do You Have Any Suggestions??? Thanks!

Reply With Quote
  #4  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: XMLA .Net Sample doesn´t workkk - 06-23-2004 , 12:42 AM



There is a very active XMLA newsgroup at microsoft.public.data.xmlanalysis
I would repost this request over there. I am sure that someone will be able
to help you.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Juan" <Juan (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the
datasource.xml file, as follow:
DataSource
DataSourceName>FoodMart 2000</DataSourceName
DataSourceDescription>Microsoft Analysis Server 2000 on local
machine</DataSourceDescription
URL>http://localhost/xmla/msxisapi.dll</URL
DataSourceInfo>Provider=MSOLAP.2;Data Source=md001144</DataSourceInfo
ProviderName>Microsoft XML for Analysis</ProviderName
ProviderType
TDP/
MDP/
DMP/
/ProviderType
AuthenticationMode>Unauthenticated</AuthenticationMode
/DataSource

Then i created a Virtual Directory as mentioned in the sdk help
but when i try to connect using the Sample.Net included in the sdk,
the application shows a Message Box: "No Catalog Found at this session"

In the Analysis Server i have two servers running:
mdsqlserver
and
md001144 (local) in which i have the FoorMart 2000 Sample (the one i want
to access)
Do You Have Any Suggestions??? Thanks!



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.