ODBC Timeout problem.
I am trying to use the query timeout of the ODBC specification while accessing an Oracle 8i database from within a client code written in MS Visual C++ 6.0.
I use Oracle's ODBC driver version 8.01.07.810.
(Microsoft's ODBC driver for Oracle does not implement
the ODBC Timeout feature).
During my tests I use a special stored procedure which
forces my call to wait for a specified number of seconds far much than the amount I specifed in my client code
(via setting the SQL_ATTR_QUERY_TIMEOUT attribute with
SQLSetStmtAttr).
I use synchronous query execution, and ideally my code should block until either a response arrives from the database or timeout ocurs. Unfortunately, my blocked query execution never timeouts and waits until the database responds. "Enable Query Timeout" box is checked witin the ODBC Driver configuration window for the system DSN I use to access the database.
When I try the same test setting with an MS_SQL Sever instead of an Oracle connection (via the Microsoft's driver manager for SQL Server as expected), everyting works fine and the timeout occurs.
Is there anyone who has an idea on why this could happen?
Many thanks in advance.
A.F.Ates