Re: ADMD.net connection problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 12:54:28 -0700

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@remove.b-f.com> wrote in message
news:OQiOo35rEHA.3324@TK2MSFTNGP15.phx.gbl...
> 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.
>
>

Relevant Pages

  • Re: RPCoHTTP always has 4 failures
    ... ON fast networks, connect using HTTP first, then connect using TCP/IP ... Outlook doesn't even prompt me to log in, it just says the server is ... Warning If you use Registry Editor incorrectly, ... It always shows HTTPS as the protocol in the connection ...
    (microsoft.public.exchange.admin)
  • Re: rpc over http connection problem
    ... HTTP Error 403.2 - Forbidden: ... it is important that you don't get any warning or etc. for certificate. ... >> i have single exch2003sp1 on w2003ent server. ... but the status keeps on remaining trying connection. ...
    (microsoft.public.exchange.connectivity)
  • Re: HTTP DDoS attack on our servers
    ... Server administration, security, programming, consulting. ... HTTP DDoS attack on our servers ... > handle HTTP requests at all and immediately closed the connection after ...
    (Incidents)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: .net 2 and ADOMD
    ... I now get the same problem when I try to retieve catalogs from a remote ... TCP but rmote TCP connection takes roughly 20 seconds. ... I will alter our code to be configuarable to use TCP or HTTP. ... or use a direct connection to your server. ...
    (microsoft.public.sqlserver.olap)