|
Home > Archive > MS SQL Server OLAP > November 2005 > Can't get all info using XMLA
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can't get all info using XMLA
|
|
| Val Matison 2005-11-24, 8:23 pm |
| 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
| |
| Val Matison 2005-11-24, 8:23 pm |
| This is an issue with SQL Server 2005 only. Everything works well in 2000.
"Val Matison" < vmatison@infoinfoinf
o.com> wrote in message
news:edUJpWU8FHA.1416@TK2MSFTNGP09.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
>
| |
| Val Matison 2005-11-25, 11:23 am |
| I finally have this resolved. It was a security issue. <s>
"Val Matison" < vmatison@infoinfoinf
o.com> wrote in message
news:e0HqZqU8FHA.3984@TK2MSFTNGP11.phx.gbl...
> This is an issue with SQL Server 2005 only. Everything works well in 2000.
>
> "Val Matison" < vmatison@infoinfoinf
o.com> wrote in message
> news:edUJpWU8FHA.1416@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|
|