I'm having a problem getting consistent results when specifying the CommandTimeout property of the ADO Command object. Sometimes the query will timeout when the value I specified is reached (50 seconds), other times the query executes fine (while exceeding the timeout value), and other times the ASP page will timeout before the query does (5 minutes).
I've tried several different scenarios and used several different timeout values and can't explain the random behavior for the life of me. Has anyone else experienced this? Any advice? I've thought about forgoing the Command object altogether and just executing the query using the Connection object and using the CommandTimeout property there, but haven't experimented with that yet. Thanks! -- Ross St. Clair --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
