Timeout

• 
  It's timeout when master..sqlbackup execute more than 40 sec in vbs.
  I use "provider=sqloledb" to do backup/restore.
  It's a bug about extented stored procedure ?
  It seems okay when execute in command line, but I need to remote backup. Do you have any idea for that ? Thanks a lot.

  mago August 29, 2005 22:41

  - 0 +
• 
  Hello Mago,
  
  I'm sure that it's not an extended stored procedure bug. You can verify this by running the query in Query Analyzer and checking the result.
  
  What technology are you using in your VBScript? You could conceivably use SQLDMO object library's ExecuteWithResultsAndMessages() or you could be using ADODB object library.

  Brian Donahue August 30, 2005 05:30

  - 0 +
• 
  It's not a bug, but really very strange.
  
  I use "ADODB" object. I already enlarged connection and command time out. It's useless. Even, I modify default value of remote query timeout in sql server. It still don't work.
  
  If backup procedure executes over 40 secs, it's always return error message and quit vbs.
  
  Could you please try to review this problem ?
  Thanks a lot.

  mago August 30, 2005 05:42

  - 0 +
• 
  I don't suppose you'd be willing to post the script, or an excerpt of the script?

  Brian Donahue August 30, 2005 06:16

  - 0 +
• 
  Assuming the timeout is initiated by vbs itself, would this be applicable to your situation? http://groups.google.com/group/microsoft.public.scripting.vbscript/tree/browse_frm/thread/1e9ee19846f6d5d8/b9e91d5361dd7591?rnum=1&q=timeout+vbscript+40&_done=%2Fgroup%2Fmicrosoft.public.scripting.vbscript%2Fbrowse_frm%2Fthread%2F1e9ee19846f6d5d8%2Fc04193003d44d387%3Flnk%3Dst%26q%3Dtimeout+vbscript+40%26rnum%3D2%26#doc_af1873596ae33784

  petey August 30, 2005 06:48

  - 0 +

Add comment

Please sign in to leave a comment.