SQL_ATTR_QUERY_TIMEOUT setting problems....

[Cary Ng]

I'm having difficulty setting the SQL_ATTR_QUERY_TIMEOUT attribute.

I do the following:

SQLUINTEGER value = 3;
rc = SQLSetStmtAttr( hstmt, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)value, SQL_IS_UINTEGER );

Then, rc returns SQL_SUCCESS. But when I perform SQLExecDirect(), it still doesn't use the 3 second timeout. So I try to do an SQLGetStmtAttr(), and it appears that the timeout value is still at default, which is 0.

I have tried SQLSetStmtAttr on other attributes such as SQL_ATTR_ROW_ARRAY_SIZE, and it seems to be working fine. Could it be a bug because SQL_ATTR_QUERY_TIMEOUT is defined as 0?

Please advise. Thanks.