I'm trying to modify an existing component to work correctly with both 2000
and 2005 cubes. However, certain differences mean that I need to know which
ones I'm talking to. I currently make a single connection using ADOMD
(COM-based). How can I tell which version of Analysis Services I'm connected
to?

Tony Proctor

the adomdconnection object provides a property called serverversion


"Tony Proctor" <tony_proctor (AT) aimtechnology_NoMoreSPAM_ (DOT) com> wrote

This is the COM version I'm using. However, I did find a connection property
called "DBMS Version". Although the documentation is a little ambiguous
about what it presents, it does seem to be what I'm after. This is confirmed
by the "DBMS Name" property being "OLAP Server" too, which makes sense since
a "Provider=MSOLAP" clause had been specified in the connection string.

Thanks anyway

Tony Proctor

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote