Hello All, I am very new with MDX queries and stuck out with one
place..your help is needed. we are having a application built in
ASP.NET, at one place the MDX query is getting very much time to get
executed and we dont want to sit the user who is accessing that query
from web, so we need to set timeout property for that query hence for
certain time limit if the result doesn't come up that query get stop and
user can have message. We tried a lot but no one option is working, so
please guide how do we sent timeout property. Here is the code..


Dim cnolap As New ADODB.Connection
Dim cell As New ADOMD.Cellset
cnolap.Open(ConfigurationSettings.AppSettings("con nectionMD"))
cell.ActiveConnection = cnolap

cell.Open(mdxqry)

session("cell")=cell
response.write("Complete")
Response.Flush()


*** Sent via Developersdex http://www.developersdex.com ***

You will need SP4 of AS in order for the following to work:


cnolap.Open(ConfigurationSettings.AppSettings("con nectionMD") + ";Timeout="
+ ConfigurationSettings.AppSettings("queryTimeout"))


--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Dev B" <bdplindia (AT) yahoo (DOT) com> wrote