The query timeout period expires before the data source returns the result set. The timeout period is set through SQLSetStmtOption : SQL_ATTR_QUERY_TIMEOUT.
For example, if the query timeout is set to 2 seconds, the query execution is canceled at the end of 2 seconds[i.e if execution takes more than 2 seconds]
Setting the timeout to 0 secs is not recommended, as it will wait forever to get the result set.
Sample error message : STMT:00 [HYT00][0] [Microsoft][SQL Server Native Client 10.0]Query timeout expired "
No comments:
Post a Comment