Timeout (clsServer)
.gif "ms133878.note(zh-tw,SQL.90).gif") 附註： |
|---|
| 下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 |
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
備註
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).
範例
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