Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] Third Party Tools
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 03-05-2009, 12:12 PM
avasily avasily is online now
Registered User
 
Join Date: 03-05-2009
Posts: 1
ADO step timeout

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.
Reply With Quote
  #2  
Old 03-05-2009, 03:30 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
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
Reply With Quote
  #3  
Old 10-14-2009, 06:04 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
This is available in v7.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 05:49 PM.


Copyright © 1999-2023 Kinook Software, Inc.