From: | Hiroshi Inoue <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-05-24 21:13:23 |
Message-ID: | 519FD7F3.7050209@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2013-05-24 21:25:07 | Re: Segmentation Fault in Postgres server when using psqlODBC |
Previous Message | Hiroshi Inoue | 2013-05-24 21:04:01 | Re: ODBC does not handle WITH clause |