ADOMD.NET problem connecting to Analysis Server 2000

  • Thread starter Thread starter protoherring
  • Start date Start date
P

protoherring

Hi,

I have the following environment:

Visual Studio 2003 / .NET 1.1
SQL Server 2000 Developer version, with Analysis Services.

I am having difficulty connecting to my cube from .NET. I CAN connect
to the cube using the included "MDX Sample Application", which (I read
somewhere) uses ADOMD.

When I try to connect from .NET, using this code:
Dim connString As String = "Data
Source=[server];Catalog=[catalog];Provider=MSOLAP;ConnectTo=8.0"
Dim conn As New AdomdConnection(connString)
conn.Open()

I get this error:

[COMException (0x80040154): An unidentified error was returned by an
external object to the XML for Analysis Provider.]

Microsoft.AnalysisServices.AdomdClient.XASC.Microsoft.AnalysisServices.AdomdClient.IXASC.ProcessRequest(Object
RequestStream) +0

Microsoft.AnalysisServices.AdomdClient.StreamInteropHelper.ProcessRequest(XASC
comClass, Stream requestStream)

Microsoft.AnalysisServices.AdomdClient.IXMLAStream.WriteEndOfMessage()

[AdomdConnectionException: The connection either timed out or was
lost.]
Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()

Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean
endReceivalIfException, Boolean readSession, Boolean
readNamespaceCompatibility)

Microsoft.AnalysisServices.AdomdClient.XmlaClient.DiscoverWithCreateSession(String
discoverType, ListDictionary properties, Boolean
sendNamespacesCompatibility)

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection
+IXmlaClientProviderEx.DiscoverWithCreateSession(String requestType,
Boolean sendNamespaceCompatibility)

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.RetrieveSchemaRowsets(Boolean
createSession)

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean
createSession)
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
Sandbox.AdoMdTestForm.doTest() in c:\inetpub\wwwroot\Sandbox\_server
\AdoMdTestForm.aspx.vb:33
Sandbox.AdoMdTestForm.Page_Load(Object sender, EventArgs e) in c:
\inetpub\wwwroot\Sandbox\_server\AdoMdTestForm.aspx.vb:27
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()



Can anyone help?

Thanks

Chris
 
Back
Top