Re: ODBC SELECT Timeout

From: "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp>
To: ter062424 <ter062424(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC SELECT Timeout
Date: 2013-06-02 23:58:23
Message-ID: 51ABDC1F.2010404@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Sorry for teh late reply.

(2013/05/29 5:20), ter062424 wrote:
> Hello Hiroshi,
>
> I set UseServerSidePrepare=1 in /etc/odbcinst.ini and then ran odbcinst -i
> -d -f /etc/odbcinst.ini.

I don't know well about odbcinst.
Does the above operation update odbc.ini?

> The SELECT query over ODBC ran for about 1 hour,
> and then died with:

Could you try
explain <the query>
using psql etc?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2013-06-03 11:33:00 Re: SQL_ERROR on SQLExecute() when using SQL_C_NUMERIC for parameters
Previous Message ljwilson 2013-06-01 22:39:28 Re: UseDeclareFetch=1, Fetch=100, UseServerSidePrepare=1 causes Windows client to intermittently hang