Re: ODBC SELECT Timeout

Поиск
Список
Период
Сортировка
От ter062424
Тема Re: ODBC SELECT Timeout
Дата
Msg-id CAJ9M9Gu77Vvicdr+tgg39EPS=x=0ArPwDf-1ByqbAaHRhXZG4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ODBC SELECT Timeout  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
Список pgsql-odbc
Дерево обсуждения
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] <[hidden email]> 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])
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.
NAML


View this message in context: Re: ODBC SELECT Timeout
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

В списке pgsql-odbc по дате отправления: