When connected to Footmart 2000, I get the following exception when calling
GetSchemaDataset(AdomdSchemaGuid.Hierarchies, <etc>) for the Measures
dimension:

"Unable to cast COM object of type
'Microsoft.AnalysisServices.AdomdClient.XASC' to interface type
'Microsoft.AnalysisServices.AdomdClient.IXASC'. This operation failed
because the QueryInterface call on the COM component for the interface with
IID '{33B2B132-69BE-4ADE-A90E-939972B93FD5}' failed due to the following
error: No such interface supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE)).

This does not happen for any other Dimension (AFAIK), nor does it happen
connecting to an AS2005 cube. I'm using ADOMD 9.0, .NET 2.0, VS2005. I've
tried this against AS2000 on a Win2k server and a Win2k3 server with the
same results.

Could anyone give me a better idea of what is going on here? Do I have to
do some special magic to get a .NET 2.0/ADOMD.NET 9.0 client to successfilly
connect to an AS2000 server? I was under that impression that I wouldn't
have to.

Thanks!

Keith

OK,

I still have this problem...no one has any ideas or suggestions for me?

Keith


"Keith" <keith (AT) alh (DOT) com> wrote

hello Keith,

in general you should be able to work with AS2000 server with adomd.net 90.

usually, i'd say that the error you see, would indicate that IXMLA component
is not properly registered/installed on the box. however, it looks like in
your case connection.Open() succeeds and other requests as well, which is
unclear.

still, could you please check that you have msadomdx.dll in the
%ProgramFiles%\Microsoft.NET\ADOMD.NET\90\
folder (note 90)? what version is it? can you re-register it and see if it
helps? (regsvr32 msadomdx.dll) ?

if you still see the issue, could you please provide an exact schema request
you are using?
could you also wrap the code into something like the try-catch below, and
capture the output (to give more error details and stack traces).
also, could you confirm that connection.Open() and some other requests
(which) succeed? and only the GetSchemaDataSet(<hierarchies in measures
dimension>) fails?

try

{

// code here

}

catch (Exception e)

{

Exception ex = e;

while (ex != null)

{

Debug.WriteLine("========Exception================ ");

Debug.WriteLine("Type: " + ex.GetType().FullName);

Debug.WriteLine("Message: " + ex.Message);

Debug.WriteLine("Stack :" + ex.StackTrace);



AdomdErrorResponseException errResponse = ex as

AdomdErrorResponseException;

AdomdConnectionException conException = ex as

AdomdConnectionException;



if (errResponse != null)

{

foreach (AdomdError r in errResponse.Errors)

{

Debug.WriteLine("::::ERROR::::");

Debug.WriteLine("code: " +

r.ErrorCode.ToString());

Debug.WriteLine("msg: " + r.Message);

}

}

else if (conException != null)

{

Debug.WriteLine("ExceptionCause:" +

conException.ExceptionCause.ToString());

}

ex = ex.InnerException;

}

} // catch


thank you,
- mary
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Keith" <keith (AT) alh (DOT) com> wrote