Re: ODBC SELECT Timeout

Hello,

(2013/05/23 2:08), ter062424 wrote:
> Hello,
>
> I have a very large, long running query that is being run on a CentOS 6
> Linux box from an application using unixODBC 2.2.14 and postgresql-odbc 8.4.
> The target database is a postgreSQL 8.4 DB on another CentOS 6 Linux box.
>
> When run, the query runs for about one hour and then dies with the following
> error:
>
> for SQL input object "SQL-AR":  SQLNumResultCols: -1/1; S1000/[unixODBC]No
> query has been executed with that handle
>
> I'm no overly familiar with using ODBC and have been researching this as
> best as I can.  I've tried to add UseDeclareFetch to /etc/odbcinst.ini as
> well, thinking that may be the cause.  Note that other queries run fine.
> I'm not sure if it is timing out, or what is happening.  Does anyone know
> what this error could mean, and if there is anything I can put in my
> /etc/odbcinst.ini to help resolve the problem.
>
> My /etc/odbcinst.ini currently looks like this:
>
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/psqlodbc.so
> Setup           = /usr/lib/libodbcpsqlS.so
> Driver64                = /usr/lib64/psqlodbc.so
> Setup64         = /usr/lib64/libodbcpsqlS.so
> UseDeclareFetch         = 1
> Fetch           = 100
> UseServerSidePrepare            = 0

Could please try
   UseServerSidePrepare = 1
?

regards,
Hiroshi Inoue