Kbase P155863: Does our ODBC driver support the cancelation of an SQL query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/27/2010 |
|
Status: Verified
GOAL:
Does our ODBC driver support the cancelation of an SQL query?
GOAL:
Is there a setting to make the query cancellable?
GOAL:
How to cancel an ODBC SQL query?
GOAL:
How can a running query be interrupted?
GOAL:
How to control the timeout value for an SQL query?
GOAL:
How to set the QUERY_TIMEOUT prperty for an SQL connection?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
1. The OpenEdge ODBC drivers do not support the cancellation of a running query at this time.
2. As a workaround, the ODBC client can execute the statement: SET PRO_CONNECT QUERY_TIMEOUT n may be executed to set a timeout value for a query. In this statement, n is the maximum number of seconds a query will run before it is canceled by the server.
3. Alternatively, your promon may be used to terminate the connection running the query.