Re: ODBC SELECT Timeout - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: ODBC SELECT Timeout
Date
Msg-id 51ABDC1F.2010404@tpf.co.jp
Whole thread Raw
In response to Re: ODBC SELECT Timeout  (ter062424 <ter062424@gmail.com>)
Responses Re: ODBC SELECT Timeout
List 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



pgsql-odbc by date:

Previous
From: ljwilson
Date:
Subject: Re: UseDeclareFetch=1, Fetch=100, UseServerSidePrepare=1 causes Windows client to intermittently hang
Next
From: Hiroshi Inoue
Date:
Subject: Re: SQL_ERROR on SQLExecute() when using SQL_C_NUMERIC for parameters