Hi,

Our application uses an Oracle 9i database as the backend. We
currently use native OCI interface to the backend, but are about to
move to an ODBC interface instead, and are exploring some third-party
Oracle ODBC drivers such as easysoft(www.easysoft.com) and datadirect
(www.datadirect.com). Also, as part of our application, we wish to set
database query timeouts so that database latency can be controlled. We
have heard of the SQL_ATTR_QUERY_TIMEOUT parameter of the
SQLSetStmtAttr function, but are not able to find out whether the
above mentioned ODBC drivers supportthis parameter or not. Does anyone
onthis list have any idea about this, or any other ODBC implementation
that supports this parameter? Or is there some other mechanism by
which an application using ODBC can control the query execution time?

Any pointers will be highly appreciated.

TIA,
Aparna.