PDA

View Full Version : ADO step timeout


avasily
03-05-2009, 11:12 AM
Hello,

I'm using "ADO" step to truncate data from MSSQL database tables.
Default timeout for this step is 30 seconds - sometimes it's not enough and step returns "Timeout Expired..." message.
Do you know how to increase this timeout value?
"CommandTimeout" property doesn't work.

Thank you.

kinook
03-05-2009, 02:30 PM
The ConnectionTimeout property applies to the database connection, not the command being executed. It's not currently possible to set the command timeout within the ADO action. We'll add this to the request list. For now, you may want to use a Run SQL action instead.
http://www.kinook.com/VisBuildPro/Manual/runsql.htm

kinook
10-14-2009, 06:04 PM
This is available in v7.