Re: ADO CommandTimeout vs Postgres statement_timeout parameter

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Richard Hetherington

Hi, I have been debugging why the ADO CommandTimeout property has no effect on Postgres Queries and I believe that it is being ignored. Is this something that could be modified in a future ODBC Driver release. What I would like to see is an auto prepending of this value to a SQL Query being passed in if set.

I guess you are right.  The current psqlODBC does not implement SQLSetConnectAttr/SQLSetStmtAttr(SQL_QUERY_TIMEOUT) and do nothing when it is called, as follows:

                         case SQL_QUERY_TIMEOUT:            /* ignored */

                                       mylog("SetStmtOption: SQL_QUERY_TIMEOUT, vParam = " FORMAT_LEN "\n", vParam);

                                       /* "0" returned in SQLGetStmtOption */

                                       break;

But I don't know whether setting ADO's CommandTimeout leads to setting SQL_QUERY_TIMEOUT.  Could you show us the MyLog output of psqlODBC to confirm that?

Regards

Takayuki Tsunakawa