Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] Third Party Tools

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

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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 06:42 AM.


Copyright © 1999-2023 Kinook Software, Inc.