PC Review


Reply
Thread Tools Rate Thread

ADOMD.NET problem connecting to Analysis Server 2000

 
 
protoherring@gmail.com
Guest
Posts: n/a
 
      30th Oct 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADOMD.NET 9 and Analysis Services 2000 =?Utf-8?B?cWFsZXhpcw==?= Microsoft ADO .NET 0 6th Nov 2007 08:05 PM
Problem connecting to SQL Server 2000 John Yung Microsoft ADO .NET 9 31st Jan 2006 12:03 AM
Problem in Connecting to my desktop SQL Server 2000 from Pocket PC 2000 venkateswarag@gmail.com Microsoft Dot NET Compact Framework 2 30th Jan 2006 11:34 AM
connecting to MS Analysis Server wooz Microsoft Dot NET Compact Framework 5 30th Sep 2004 11:48 PM
Analysis Services with ADO.NET (OleDB) + ADOMD with .net Lars-Erik Aabech Microsoft ADO .NET 0 2nd Sep 2003 12:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 AM.