Hi all,
I have a web app written in asp.net c# that connects to AS2000.
When I run it on the client connection string:
connectionString1="provider=msolap;Data Source=server1;initial
catalog=foodmart 2000;"
works fine. (note: server1 is NOT locahost but Win.Server 2000 machine
running AS2000 SP3).
When I deploy the app to the production server with corrected conn string
(I
have a basic authentication on the virtual dir):
connectionString2="provider=msolap;Data Source=prodServer;initial
catalog=foodmart 2000;"
I get:
----------------------------------------------------------------
ERROR TYPE 1:
[SocketException (0x274d): No connection could be made because the target
machine actively refused it]
System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
SocketAddress socketAddress) +1002002
System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +84
System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +145
System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 ****t)
+200
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String
hostName, Int32 ****t) +295
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo
connectionInfo) +139
[AdomdConnectionException: A connection cannot be made. Ensure that the
server is running.]
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo
connectionInfo) +376
Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo
connectionInfo) +49
Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo
connectionInfo, Boolean beginSession) +497
Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
+129
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean
createSession, Boolean isHTTP) +126
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +343
----------------------------------------------------------------
If I include username and password:
connectionString3="provider=MSOLAP;Data Source=prodServer;Catalog=Foodmart
2000;UID=XXX;PWD=****;"
I get the same error:No connection could be made because the target
machine
actively refused it
Now, if I include the ConnectTo=8.0:
connectionString4="provider=MSOLAP;Data Source=prodServer;Catalog=Foodmart
2000;UID=XXX;PWD=****;ConnectTo=8.0:"
I get a different kind of error:
----------------------------------------------------------------
ERROR TYPE 2:
[COMException (0x80040154): Retrieving the COM class factory for component
with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the
following error: 80040154.]
Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor() +32
[AdomdConnectionException: A connection cannot be made. Ensure that the
server is running.]
Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo
connectionInfo) +105
Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo
connectionInfo, Boolean beginSession) +497
Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo
connectionInfo, String sessionID) +47
Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
+116
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean
createSession) +114
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +343
----------------------------------------------------------------
which is strange because the do***entation claims to attempt the 9.0 and
then 8.0 by default:
http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.adomdconnection.connectionstring.aspx
"Sets the method that the AdomdConnection uses used to connect to the
server. If set to 8.0, the connection uses in-process XML for Analysis to
connect to the server. If set to 9.0, the connection uses XML for
Analysis.
If set to Default, the connection first tries XML for Analysis, and then
tries to use in-process XML for Analysis."
?
However, if I use XMLA and change Data Source=prodServer to Data
Source=http://prodServer/xmla/msxisapi.dll
everything works fine
(obviously
I have XMLA installed).
Question is:
1. Why do I get different errors?
2. How do I correct ERROR TYPE 2 so that I can connect to AS2000 without
XMLA (which is slower I guess)?
I know it can be done because that's how I connect to server1 from my
localhost in development.
Aplogies for the lenghty post.
Regards,
Igor
Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET
Version:2.0.50727.42
|
