Re: ODBC SELECT Timeout

Hello Hiroshi,

Thank you for your continued help on this, it is greatly appreciated. The
system with ODBC installed is a CentOS Linux server and has two files:
"/etc/odbc.ini" and "/etc/odbcinst.ini" The odbcinst.ini file is where the
[PostgreSQL] section is defined, showing the path to the driver, etc.
(Driver64 = /usr/lib64/psqlodbc.so). That is where I was putting these
values.

Perhaps I should have been putting then in odbc.ini. I will work on that
and re-test. I'll also run an EXPLAIN and let you know how it turns out.

Thanks again for the help.
Tom

On Sun, Jun 2, 2013 at 7:59 PM, Inoue, Hiroshi [via PostgreSQL] <
ml-node+s1045698n5757740h2(at)n5(dot)nabble(dot)com> wrote:

> 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
>
>
>
> --
> Sent via pgsql-odbc mailing list ([hidden email]<http://user/SendEmail.jtp?type=node&node=5757740&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-tp5756490p5757740.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-tp5756490p5757800.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.