Is there a setting in Analysis Services 2000 that controls how long the
drillthrough query can run before timing out?

Stan

http://groups-beta.google.com/group/...rver.olap/msg/
2f4bfb66580e83b9?hl=en
timeout limit may be adjustable:

http://groups-beta.google.com/*group...serv*er.olap/m.
..

linda deng[MS] Sep 11 2002, 11:38 pm show options

Newsgroups: microsoft.public.sqlserver.ola*p
From: lid... (AT) online (DOT) microsoft.com (linda deng[MS])
Date: Thu, 12 Sep 2002 06:26:42 GMT
Local: Wed, Sep 11 2002 11:26 pm
Subject: RE: Drillthrough and Timeout

Hi Joe,

The default timeout value is 30 seconds for the drillthrough in Analysis
Server 2000. If you use drillthrough in Analysis Manager, you cannot
re-set
the timeout value. However, if you access with your client application,
you
can re-set the value by setting the CommandTimeout property to a larger
value.

Sincerely,

Linda Deng
Microsoft Support Engineer

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks, this helps. However it doesn't seem to work with all database
providers. I got it working with SQL Server data source but it seems to have
no effect when the data source is MS Access. I'm using the following ADO.NET
code:

oDA = New OleDb.OleDbDataAdapter(szSQL, m_clConnection.ConnectionString)
oCB = New OleDb.OleDbCommandBuilder(oDA)
oCB.QuotePrefix = "["
oCB.QuoteSuffix = "]"
If i_nTimeout >= 0 Then
oDA.SelectCommand.CommandTimeout = i_nTimeout
End If
oDA.Fill(dsDrillthroughSet)

Any ideas?

Thanks,
Stan
"Deepak Puri" wrote: