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 |