Connect to AS2000 using adomd

Connect to AS2000 using adomd

Post by Igor » Sat, 15 Jul 2006 01:18:03


i 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 port) +200
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String
hostName, Int32 port) +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.AnalysisSer
 
 
 

Connect to AS2000 using adomd

Post by Akshai Mir » Sat, 15 Jul 2006 06:26:42

t looks like the IXMLA component is not working -- probably it is not
installed or not available because of a dependency...

Try to re-register the component -- go to the folder C:\Program
Files\Microsoft.NET\ADOMD.NET\90
and do:
regsvr32 msadomdx.dll
This should re-register the COM objects in this DLL -- and if this fails,
hopefully it will indicate what may be the problem (e.g. MSXML6 not
installed?).

HTH,
Akshai
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Igor" < XXXX@XXXXX.COM > wrote in message
news:e95rns$l1e$ XXXX@XXXXX.COM ...



 
 
 

Connect to AS2000 using adomd

Post by Igor » Sat, 15 Jul 2006 19:13:36

hank you Akshai - I was missing MSXML6.
To be more precise I've installed MSXML6_SDK from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=enthinking that SDK includes XML parser or whatever it is I need.Only when I installed :msxml6.msi (1.5 MB)from the same page it worked. Differences in those files are not explainedon the page or I missed it.Thanks again,IgorBTW, for those struggling with similar issues I found this link useful too:http://www.dbtalk.net/microsoft-public-sqlserver-olap/cannot-connect-msas-2000-server-177366.html"Akshai Mirchandani [MS]" < XXXX@XXXXX.COM > wrote in messagenews: XXXX@XXXXX.COM ...> It looks like the IXMLA component is not working -- probably it is notinstalled or not available because of a dependency...>> Try to re-register the component -- go to the folder C:\ProgramFiles\Microsoft.NET\ADOMD.NET\90> and do:> regsvr32 msadomdx.dll> This should re-register the COM objects in this DLL -- and if this fails,hopefully it will indicate what may be the problem (e.g. MSXML6 notinstalled?).>> HTH,> Akshai> --> Try out the MSDN Forums for Analysis Services at:> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1>> This posting is provided "AS IS" with no warranties, and confers no rights> Please do not send email directly to this alias. This alias is fornewsgroup> purposes only.>> "Igor" < XXXX@XXXXX.COM > wrote in messagenews:e95rns$l1e$ XXXX@XXXXX.COM ...>> 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;initialcatalog=foodmart 2000;">>>> works fine. (note: server1 is NOT locahost but Win.Server 2000 machinerunning 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;initialcatalog=foodmart 2000;">>>> I get:>> ---------------------------------------------------------------->> ERROR TYPE 1:>> [SocketException (0x274d): No connection could be made because the targetmachine 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 port)+200>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port) +295>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +139>>>> [AdomdConnectionException: A connection cannot be made. Ensure that theserver is running.]>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +376>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +49>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfoconnectionInfo, Boolean beginSession) +497>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServi
 
 
 

Connect to AS2000 using adomd

Post by Igor » Sat, 15 Jul 2006 19:58:04

this is repost - something happend with the '\n''s):

Thank you Akshai - I was missing MSXML6.

To be more precise I've installed MSXML6_SDK from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=enthinkingthat SDK includes XML parser or whatever it is I need.Only when I installed :msxml6.msi (1.5 MB)from the same page it worked.Differences in those files are not explainedon the page or I missed it.Thanks again,IgorBTW, for those struggling with similar issues I found this link useful too:http://www.dbtalk.net/microsoft-public-sqlserver-olap/cannot-connect-msas-2000-server-177366.html"Akshai Mirchandani [MS]" < XXXX@XXXXX.COM > wrote in messagenews: XXXX@XXXXX.COM ...> It looks like the IXMLA component is not working -- probably it is notinstalled or not available because of a dependency...>> Try to re-register the component -- go to the folder C:\ProgramFiles\Microsoft.NET\ADOMD.NET\90> and do:> regsvr32 msadomdx.dll> This should re-register the COM objects in this DLL -- and if this fails,hopefully it will indicate what may be the problem (e.g. MSXML6 notinstalled?).>> HTH,> Akshai> --> Try out the MSDN Forums for Analysis Services at:> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1>> This posting is provided "AS IS" with no warranties, and confers no rights> Please do not send email directly to this alias. This alias is fornewsgroup> purposes only.>> "Igor" < XXXX@XXXXX.COM > wrote in messagenews:e95rns$l1e$ XXXX@XXXXX.COM ...>> 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;initialcatalog=foodmart 2000;">>>> works fine. (note: server1 is NOT locahost but Win.Server 2000 machinerunning 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;initialcatalog=foodmart 2000;">>>> I get:>> ---------------------------------------------------------------->> ERROR TYPE 1:>> [SocketException (0x274d): No connection could be made because the targetmachine 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 port)+200>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port) +295>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +139>>>> [AdomdConnectionException: A connection cannot be made. Ensure that theserver is running.]>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +376>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +49>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfoconnectionInfo, Boolean beginSession) +497>>>>Microsoft.AnalysisServ