The SQL_ATTR_CONNECTION_TIMEOUT only applies to calling SQLConnect. If the remote server does not accept the connection, this is the maximum amount of time it will take for the function to return.
The SQL_ATTR_QUERY_TIMEOUT is not supported by the psqlodbc driver.
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of joy chen
Sent: Friday, December 10, 2004 1:06 PM
Subject: [ODBC] question about timeout attributes
I am playing out these timeout attributes:
SQL_ATTR_QUERY_TIMEOUT. Basically I set the connection
timeout to 1 sec after a connection is made and query
timeout to 1 sec after a statement handle is
allocated. And then I did the following:
1. lock a table (say dummy) manually in exclusive
2. run my program which try to query this dummy table
using the odbc interface with the same statement
To my understanding, if these timeout features are
supported correctly. My query should timeout after 1
sec. But in my test, the query just waits there
My question is therefore whether these timeout
attributes are supported by the postgresql odbc driver
at all or there is a problem in my test.
Any suggestions or recommendations are highly
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
pgsql-odbc by date
|Next:||From: Bruce Momjian||Date: 2004-12-13 02:18:27|
|Subject: Re: ODBC Rewrite|
|Previous:||From: joy chen||Date: 2004-12-10 18:06:19|
|Subject: question about timeout attributes|