Re: ODBC SELECT Timeout

Hello Hiroshi,

Thank you for the response. It'll be four days until I can test this, but
I will definitely do as you suggested and let the list know how it turns
out. Thanks again for the help.

Regards,
Tom

On Fri, May 24, 2013 at 5:14 PM, Hiroshi Inoue [via PostgreSQL] <
ml-node+s1045698n5756812h34(at)n5(dot)nabble(dot)com> wrote:

> 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
>
>
>
> --
> Sent via pgsql-odbc mailing list ([hidden email]<http://user/SendEmail.jtp?type=node&node=5756812&i=0>)
>
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://postgresql.1045698.n5.nabble.com/ODBC-SELECT-Timeout-tp5756490p5756812.html
> To unsubscribe from ODBC SELECT Timeout, click here<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5756490&code=dGVyMDYyNDI0QGdtYWlsLmNvbXw1NzU2NDkwfC0xMjg1NDg3MzI4>
> .
> NAML<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/ODBC-SELECT-Timeout-tp5756490p5756818.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.