Hi,
I'm facing a strange issue in SQL 2000 AS connectivity. I have an .dll file that talks to SQL AS 2000 and gets the Dimension Hierarchy - so display as a list in a webpart page.
I use the below code to connect to SQL AS 2000
AdomdConnection
connection = new AdomdConnection(conString)connection.Open();
where my connection string is
Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=True;Data Source=myserver;Initial Catalog=MyDataMart;Client Cache Size=25;Auto Synch Period=10000;MDX Compatibility=1.
It works well when I open the the page in Server, whereas, it doesn't when I open the user desktop browser. I end up with error
"A connection cannot be made. Ensure that server is running". The stack trace is
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at MyClass.myFunction()
Not sure why its, but I'm in a crunch situation. So any help is highly appreciated.
Regards,
Kart