Hi

I have ASP.NET web based app, using ADOMD.NET. The app needs to connect to
both AS2000 and AS2005 cubes running on separate machines. I know that if I
specify ConnectTo=8.0, the connection works with AS2000, and ConnectTo=9.0
works with AS2005. 9.0 does NOT work with AS2000 and 8.0 does NOT work with
AS2005

Manually this works. But in an automated framework this is a little
impractical. ADOMD.NEt documentation says that 9.0 should work with both. At
the moment, the only way around this is to trap the error with one type and
then run the other. This can't be efficient. Setting to "Default" creates
errors for BOTH!

Is there a a one shot solution?

thx
Avi

What the 9.0 provider does (if you don't specify ConnectTo at all) is that
it first attempts a connection to the server via 9.0 -- if that fails -- if
it gets an error -- it retries using the 8.0 provider (and setups delegation
so if it succeeds that subsequent requests are sent ot the 8.0 provider).
You could do the same thing in your code.

ADOMD.NET does not go down to the 9.0 provider if connecting to the 9.0
server -- this failover feature is for ADOMD or OLEDB legacy applications
only. In fact the 9.0 provider is not used by ADOMD.NET at all. The 9.0
provider is for legacy applications only.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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