Timeout (clsServer)
.gif "ms133878.note(fr-fr,SQL.90).gif") Remarque : |
|---|
| Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité. |
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
Notes
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).
Exemple
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