Urgent: setting a timeout property to MDX query or STOP a mdx query

Discussion in 'microsoft.public.sqlserver.olap' started by Dev B, Oct 19, 2005.

  1. Dev B

    Dev B Guest

    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("connectionMD"))
    cell.ActiveConnection = cnolap

    cell.Open(mdxqry)

    session("cell")=cell
    response.write("Complete")
    Response.Flush()
     
    Dev B, Oct 19, 2005
    #1
    1. Advertisements

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


    cnolap.Open(ConfigurationSettings.AppSettings("connectionMD") + ";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.
    ==============================­====================
     
    Mosha Pasumansky [MS], Oct 19, 2005
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.