Re: psqlodbc_x64 timeout available? - Mailing list pgsql-odbc

From Jan Espen Kleivane
Subject Re: psqlodbc_x64 timeout available?
Date
Msg-id VI1PR0801MB167893617586E6B74CA8B012D3250@VI1PR0801MB1678.eurprd08.prod.outlook.com
Whole thread Raw
In response to psqlodbc_x64 timeout available?  (Jan Espen Kleivane <jan.espen.kleivane@goodtech.no>)
Responses Re: psqlodbc_x64 timeout available?
List 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.espen.kleivane@goodtech.no

www.goodtech.no




"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@postgresql.org
Cc: espenkleivane@gmail.com; Jan Espen Kleivane <jan.espen.kleivane@goodtech.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:

 

 

 

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

 

PostgreSql:

 

Oracle:

 

 

 

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.espen.kleivane@goodtech.no

www.goodtech.no




"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"

 

 

Attachment

pgsql-odbc by date:

Previous
From: Jan Espen Kleivane
Date:
Subject: psqlodbc_x64 timeout available?
Next
From: "Koenig, Michael"
Date:
Subject: Fetch next with ODBC driver 09.05.0100 yields wrong/duplicate results