I've just downloaded the ADOMD.net classes and I am trying to use them on a
remote server (Win 2k, AS 2000, sp3 ) The code connects when I run it
against my local machine, but when I switch to the remote server I get the
following:
Server Error in '/WebApplication4' Application.
--------------------------------------------------------------------------------

No connection could be made because the target machine actively refused it
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could
be made because the target machine actively refused it

Source Error:
Line 34: Dim a As New AdomdConnection
Line 35: a.ConnectionString = "Data
Source=172.21.11.52;provider=MSOLAP;Initial Catalog=foodmart 2000;Integrated
Security=SSPI;"
Line 36: a.Open()
Line 37: Label1.Text = a.SessionID
Line 38: Label2.Text = a.ServerVersion


I'm a little confused by the documentation, but does anything need to be
installed on the server for ADOMD.net to work? I've installed the XML for
Analysis on my machine and the server and still the same problem.

Hi Scott,

ADOMD.NET supports two modes of connecting to a AS2k server:

1. It connects over HTTP to a XMLA provider -- this requires that you have
the XMLA SDK installed and you use a HTTP URL as your datasource e.g.: Data
Source=http://server/xmla/msxisapi.dll
2. You can specify "ConnectTo=8.0" in your connection string and then
ADOMD.NET can connect using the "msadomdx.dll" (aka IXMLA) component to a
AS2k server directly. In this case, your connection string can specify "Data
Source=server;ConnectTo=8.0".

The third possibility is that ADOMD.NET can connect directly to a AS2005
(beta) server over TCP/IP and the error you are seeing is because ADOMD.NET
is failing in that attempt -- if you simply specify "Data Source=server"
without a ConnectTo then the default is to connect to AS2005. So you should
configure either the first or second options...

The second option needs IXMLA installed and that would need MSXML4 installed
on the ADOMD.NET machine as well.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Scott Riehl" <scott_riehl (AT) remove (DOT) b-f.com> wrote

Thanks, but now I'm getting the following.

Server Error in '/WebApplication4' Application.
--------------------------------------------------------------------------------

Unhandled Execution Error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details:
Microsoft.AnalysisServices.AdomdClient.AdomdErrorR esponseException:

Source Error:

Line 34: Dim a As New AdomdConnection
Line 35: a.ConnectionString = "Data
Source=analysis;provider=MSOLAP;Initial Catalog=hartmann;ConnectTo=8.0"
Line 36: a.Open()
Line 37: Label1.Text = a.SessionID
Line 38: Label2.Text = a.ServerVersion


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

Scott,

Been struggling with this ourselves for awhile. We finally got it
working. Check that you have the following:

on the client machine:
-olap ole db provider 8 (comes with analysis services)
-msxml4
-adomd.net

you do not need xml for analysis if you use 'Connect To=8.0'

On the analysis server, I also had to add the client user to the
olapadminstrators group. Seems like an overkill, but without it I also
got your error.

HTH

avner


"Scott Riehl" <scott_riehl (AT) remove (DOT) b-f.com> wrote

There is an Errors collection in the AdomdErrorResponseException -- if you
take a look inside it you should get more information.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Scott Riehl" <scott_riehl (AT) remove (DOT) b-f.com> wrote