Transaction Processing
Transaction support for PivotTable® Service client applications is provided by the Microsoft® ActiveX® Data Objects (ADO) Connection object. This object provides three methods for conducting transactions against cubes and data mining models: BeginTrans, CommitTrans, and Rollback. For more information, see Performing Transactions in ADO.
Setting the Writeback Timeout Property
The amount of time that will elapse before a writeback operation times out can be specified in seconds using the Writeback Timeout Property. This property can be set by using the connection string of the ADO Connection property when a session is established. After setting this value it cannot be changed for the duration of the session. The following code sets the value of this property to 60 seconds:
dim cn as ADO.Connection
cn.Open "provider=msolap; Initial Catalog=FoodMart 2000; Datasource=LocalHost; Writeback Timeout=60;"