Hi, please may I have your assistance on how, if possible, to reuse
connections to Analysis Services from a Web Service? At present we use the
following

objAdomdConnection = New AdomdConnection(................)
objAdomdConnection.Open()
objAdomdCommand.Connection = objAdomdConnection
Dim objDeviceData As New clsDeviceData

' the following returns the MDX command string
objAdomdCommand.CommandText = objDeviceData.DeviceData( ..............
....)

' execute the MDX and return as XML and remove unwanted data
objXMLReader = objAdomdCommand.ExecuteXmlReader
objXMLReader.ReadToFollowing("Axis")
strReturnedXML = "<root><result>"
'read axis 0
strReturnedXML += objXMLReader.ReadOuterXml
'read axis 1
strReturnedXML += objXMLReader.ReadOuterXml

objXMLReader.ReadToFollowing("CellData")

strReturnedXML += objXMLReader.ReadOuterXml
strReturnedXML += "</result></root>"

objXMLReader.Close()
objAdomdConnection.Close()

Return (strReturnedXML)


Is it possible to create a multiple connections and reuse them without having
to open and close a connection to AS each time we run MDX?

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200605/1