Can't get all info using XMLA

#1

Hi,

I have tried everthing I can think of but cannot mange to get information
using XMLA. It's set up properly but any Discover messages sent to the
server using something like DBSCHEMA_CATALOGS dones not return any
information in the rows. If I take EXACTLY the same SOAP package and create
an XMLA query in SQL Server Management Studio, then I get the same info but
with the details embedded in the rows.

If I create Discover packages using XML for Analysis Rowsets then I get back
the row detail that I expect. So things like DISCOVER_DATASOURCES works
fine.

I am logged in as admin on a local machine.

Please help.

Thanks, Val

#2

This is an issue with SQL Server 2005 only. Everything works well in 2000.

"Val Matison" <vmatison (AT) infoinfoinfo (DOT) com> wrote

Quote:

Hi,

I have tried everthing I can think of but cannot mange to get information
using XMLA. It's set up properly but any Discover messages sent to the
server using something like DBSCHEMA_CATALOGS dones not return any
information in the rows. If I take EXACTLY the same SOAP package and
create an XMLA query in SQL Server Management Studio, then I get the same
info but with the details embedded in the rows.

If I create Discover packages using XML for Analysis Rowsets then I get
back the row detail that I expect. So things like DISCOVER_DATASOURCES
works fine.

I am logged in as admin on a local machine.

Please help.

Thanks, Val

#3

I finally have this resolved. It was a security issue. <s>

"Val Matison" <vmatison (AT) infoinfoinfo (DOT) com> wrote

Quote:

This is an issue with SQL Server 2005 only. Everything works well in 2000.

"Val Matison" <vmatison (AT) infoinfoinfo (DOT) com> wrote in message
news:edUJpWU8FHA.1416 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi,

I have tried everthing I can think of but cannot mange to get information
using XMLA. It's set up properly but any Discover messages sent to the
server using something like DBSCHEMA_CATALOGS dones not return any
information in the rows. If I take EXACTLY the same SOAP package and
create an XMLA query in SQL Server Management Studio, then I get the same
info but with the details embedded in the rows.

If I create Discover packages using XML for Analysis Rowsets then I get
back the row detail that I expect. So things like DISCOVER_DATASOURCES
works fine.

I am logged in as admin on a local machine.

Please help.

Thanks, Val

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can't get all info using XMLA

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

Can't get all info using XMLA - 11-24-2005 , 04:23 PM

Re: Can't get all info using XMLA - 11-24-2005 , 04:58 PM

Re: Can't get all info using XMLA - 11-25-2005 , 09:30 AM