psqlodbc_x64 timeout available?

From: Jan Espen Kleivane <jan(dot)espen(dot)kleivane(at)goodtech(dot)no>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Cc: "espenkleivane(at)gmail(dot)com" <espenkleivane(at)gmail(dot)com>, Jan Espen Kleivane <jan(dot)espen(dot)kleivane(at)goodtech(dot)no>
Subject: psqlodbc_x64 timeout available?
Date: 2016-07-01 10:01:34
Message-ID: VI1PR0801MB1678EF0C9ABA7EB06AFF0140D3250@VI1PR0801MB1678.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I am using the psqlodbc_x64 connector.
It works ok, but after some days, I believe it goes in connection timeout.

The error I get is "Connection is dead".....

When this error comes, I have to restart the application using odbc (connected to psqlodbc, to connect to PostgreSql database).
After restarting the application running the query connected to PostgreSQL , all works fine.

I am using this version of psqlodbc:

[cid:image001(dot)png(at)01D1D38F(dot)8F2B03C0]

In the odbc 64 bit app I am not able to set a timeout as I can with other connectors:

PostgreSql:
[cid:image003(dot)png(at)01D1D38F(dot)DC3B6880]

Oracle:

[cid:image004(dot)png(at)01D1D390(dot)35E9C840]

It the timeout not implemented for PostgreSql, psqlodbc?

I am using one of the newest version of psqlodbc?

How to get around this problem?

Med vennlig hilsen
Jan Espen Kleivane

_______________________________________________
Goodtech Projects & Services AS
Damsgårdsveien 125, 5160 LAKSEVÅG
Besøk: Damsgårdsveien 125, Bergen
Tel: +47 55 70 67 50
Mob: +47 413 76 635
E-post: jan(dot)espen(dot)kleivane(at)goodtech(dot)no
www.goodtech.no<http://www.goodtech.no/>

[cid:image002(dot)png(at)01D1D38F(dot)8F2B03C0]

"Tenk på miljøet før du skriver ut e-post.
For oss er det naturlig å integrere miljøarbeidet
og strebe etter kontinuerlig forbedringer i
vår daglige virksomhet - The Goodtech way"

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jan Espen Kleivane 2016-07-01 10:09:05 Re: psqlodbc_x64 timeout available?
Previous Message Venkatesan, Sekhar 2016-07-01 09:07:08 Updateable cursors ODBC configuration Partition Issue