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> |
Subject: | Re: psqlodbc_x64 timeout available? |
Date: | 2016-07-01 10:09:05 |
Message-ID: | VI1PR0801MB167893617586E6B74CA8B012D3250@VI1PR0801MB1678.eurprd08.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
The version is:
09_05_0100 of psqlodbc
Is the timeout only available in version psqlodbc_09_05_0300?
ref:
https://odbc.postgresql.org/docs/release.html
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)01D1D391(dot)5B8DBFB0]
"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"
From: Jan Espen Kleivane
Sent: 1. juli 2016 12:02
To: pgsql-odbc(at)postgresql(dot)org
Cc: espenkleivane(at)gmail(dot)com; Jan Espen Kleivane <jan(dot)espen(dot)kleivane(at)goodtech(dot)no>
Subject: psqlodbc_x64 timeout available?
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:image005(dot)png(at)01D1D391(dot)5B8DBFB0]
In the odbc 64 bit app I am not able to set a timeout as I can with other connectors:
PostgreSql:
[cid:image006(dot)png(at)01D1D391(dot)5B8DBFB0]
Oracle:
[cid:image007(dot)png(at)01D1D391(dot)5B8DBFB0]
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<mailto:jan(dot)espen(dot)kleivane(at)goodtech(dot)no>
www.goodtech.no<http://www.goodtech.no/>
[cid:image002(dot)png(at)01D1D391(dot)5B8DBFB0]
"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"
From | Date | Subject | |
---|---|---|---|
Next Message | Koenig, Michael | 2016-07-01 16:35:30 | Fetch next with ODBC driver 09.05.0100 yields wrong/duplicate results |
Previous Message | Jan Espen Kleivane | 2016-07-01 10:01:34 | psqlodbc_x64 timeout available? |