Timeout (clsServer)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The Timeout property of an object of ClassType clsServer sets or returns the maximum amount of time between reports from the Analysis server before the server is considered to have timed out.
Data Type
Long
Access
Read/write
Remarks
The default value is 3600 seconds (1 hour). Under some conditions, the server may encounter long wait times, for example, during the processing of large cubes or during queries to a source database. If you experience timeout errors under such conditions, you can increase the default value. The maximum allowed value is one million (1,000,000) seconds. This is approximately 11 days and 14 hours. To have the server wait indefinitely, set the Timeout property to zero (0).
Example
Use the following code to set the Timeout property for a server. You must call the Update method for your changes to take effect.
Dim dsoS As New DSO.Server
' Connect to the local Analysis server.
dsoServer.Connect "LocalHost"
' Set the timeout to 4 hours.
dsoServer.Timeout = 14400
' Update the Analysis server.
dsoServer.Update
' Close the connection to the Analysis server.
dsoServer.CloseServer