query timeout
От | Ondrej Dzivy Balucha |
---|---|
Тема | query timeout |
Дата | |
Msg-id | 5677FE48.8010100@horizon.sk обсуждение исходный текст |
Ответы |
Re: query timeout
|
Список | pgsql-odbc |
Hi Is there any keyword to setup query timeout? I have ODBC connection to remote PostgreSQL database. I connect to db with isql (for example), send query and i get result. Now connection lost(disconnected cable or other problem) and I send next query. No answer or error message and isql waiting and waiting and .... waiting(I was waiting for 20 minutes and no response). Is there any way to setup timeout in odbc.ini or odbcinst.ini? I know that ibm DB2 has this keyword in db2 client(ReceiveTimeout = time in seconds to wait for a reply from the server on an established connection before terminating the attempt and generating a communication timeout error). If I setup ReceiveTimeout = 5 , than I get error after 5 seconds when no response. I need setup this for PostgreSQL. Regards -- Ondrej Dzivy Balucha Horizon, s.r.o. Prešov Francisciho 21 08001 Prešov tel/fax +421517491400/02
В списке pgsql-odbc по дате отправления: