Home > Archive > MS SQL Server OLAP > January 2006 > Detecting 2000/2005 cube versions









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 Detecting 2000/2005 cube versions
Tony Proctor

2006-01-26, 4:58 pm

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


Jéjé

2006-01-26, 4:58 pm

the adomdconnection object provides a property called serverversion


"Tony Proctor" < tony_proctor@aimtech
nology_NoMoreSPAM_.com> wrote in message
news:u5DUoTZIGHA.1876@TK2MSFTNGP11.phx.gbl...
> 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
>
>



Tony Proctor

2006-01-26, 4:58 pm

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@BBBhotmailA
AA.com> wrote in message
news:eEgMflhIGHA.344@TK2MSFTNGP11.phx.gbl...
> the adomdconnection object provides a property called serverversion
>
>
> "Tony Proctor" < tony_proctor@aimtech
nology_NoMoreSPAM_.com> wrote in

message
> news:u5DUoTZIGHA.1876@TK2MSFTNGP11.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com