dbTalk Databases Forums  

Connection problem with adomd.net over asp.net

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Connection problem with adomd.net over asp.net in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marc Chouteau
 
Posts: n/a

Default Connection problem with adomd.net over asp.net - 05-07-2006 , 05:08 AM






I want to request AS 2005 with a script hosted by asp.net 2.0 but I have
this error message :

Microsoft.AnalysisServices.AdomdClient.AdomdConnec tionException: The
connection either timed out or was lost. ---> System.IO.IOException: Unable
to read data from the transport connection: An existing connection was
forcibly closed by the remote host. ---> System.Net.Sockets.SocketException:
An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32
size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset,
Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset,
Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord. ForceRead(Stream
stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord. ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord. .ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader. ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.G etDataType()
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.AdomdClient.XmlaClient. EndRequest()
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. CreateSession(ListDictionary
properties, Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Microsoft.AnalysisServices .AdomdClient.AdomdConnection.IXmlaClientProviderEx .CreateSession(Boolean
sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()

The client is Windows Server 2003 web edition SP1 with Asp.Net 2.0, the
server is Windows 2003 standard edition with SQL Server 2005 Standard
Edtion. Servers are not in same domain.

The code which generates the error :

string connectionString = "Data
Source=XXX.XXX.XXX.XXX;Catalog=MonCatalog;Provider =MSOLAP.3;";
using (AdomdConnection cnn = new AdomdConnection(connectionString))
{
cnn.Open(); <--- Error
....
}

If I use this code with a application console on the windows 2003 server,
it's ok, no error.

Marc Chouteau







Reply With Quote
Reply




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.