Hi

I'am trying to connect to a Analysis Services 2000 Server with ADOMD
..NET 8.0 (Windows App and VB .NET) but when i try the following
connectionstring:

"Provider=MSOLAP.2;Data Source=PT00013126;Integrated
Security=SSPI;Initial Catalog=Trabalho"

i get the error

"A connection cannot be made. Ensure that the server is running."

where the StackTrace 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.XmlaClientP rovider.Microsoft.AnalysisServices.AdomdClient.Ado mdConnection

+IXmlaClientProviderEx.ConnectXmla()
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean

isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at DTSIIMPivotTableFacilities.ADOMDInternal.OpenConne ction() in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\ADOMDInternal.vb:l ine
32
at DTSIIMPivotTableFacilities.ADOMDInternal..ctor(Str ing ConStr) in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\ADOMDInternal.vb:l ine
13
at
DTSIIMPivotTableFacilities.Toolbar.m_CMDProp_Click (CommandBarButton
Ctrl, Boolean& CancelDefault) in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\Toolbar.vb:line
53"

BUT WHEN I USE THE "ConnectTo" Property:

"Provider=MSOLAP.2;Data Source=PT00013126;Integrated
Security=SSPI;Initial Catalog=Trabalho;ConnectTo=8.0"

the error is

"The connection either timed out or was lost."

and the StackTrace

" at Microsoft.AnalysisServices.AdomdClient.XmlaClient. EndRequest()
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. SendMessage(Boolean
endReceivalIfException, Boolean

readSession, Boolean readNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. DiscoverWithCreateSession(String
discoverType,

ListDictionary properties, Boolean sendNamespacesCompatibility)
at

Microsoft.AnalysisServices.AdomdClient.XmlaClientP rovider.Microsoft.AnalysisServices.AdomdClient.Ado mdConnection

+IXmlaClientProviderEx.DiscoverWithCreateSession(S tring requestType,
Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.RetrieveSchemaRowsets(Boolean
createSession)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToIXMLA(Boolean
createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at DTSIIMPivotTableFacilities.ADOMDInternal.OpenConne ction() in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\ADOMDInternal.vb:l ine
32
at DTSIIMPivotTableFacilities.ADOMDInternal..ctor(Str ing ConStr) in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\ADOMDInternal.vb:l ine
13
at
DTSIIMPivotTableFacilities.Toolbar.m_CMDProp_Click (CommandBarButton
Ctrl, Boolean& CancelDefault) in

D:\OLAP\DTSIIMPivotTableFacilities\PivotTableFacii ties\DTSIIMPivotTableFacilities\Toolbar.vb:line
53"

Any help ?

Desbaratizador wrote:
SOLVED: after instaling MSXML 4

do you add impersonation =true in your Web.config file?