Hi

I am trying to retrieve a list of catalogs in an ASP page from an AS2K
server, using DSO (since one can't do that with ADOMD). I have the syntax
correct, except I am getting authentication issues *I think*.

When I log into the site, urinsg Basic Authentication and an OLAP Admin
account, the code returns the list. If I use a normal user's account - it
doesn't - even though this user has been given access to certain catalogs
and cubes on the server.

Is there something I could do better? Is there a way around it? Keep in
mind, I only want the list of relevant catalogs to be returned for that
user - not the entire list.

thanks
Avi

Hello Avi,
you can get a the list of catalog with ADOMD:

VB Syntax:
dim conn as new adodb.connection
dim rec as new adodb.recordset
conn.open "Provider=msol...."
set rec = conn.OpenSchema(adSchemaCatalogs....)

HTH
Jörg

thanks

that did the trick

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

Hello Avi,
you can get a the list of catalog with ADOMD:

VB Syntax:
dim conn as new adodb.connection
dim rec as new adodb.recordset
conn.open "Provider=msol...."
set rec = conn.OpenSchema(adSchemaCatalogs....)

HTH
Jörg