Hello Hiroshi,
I set UseServerSidePrepare=1 in /etc/odbcinst.ini and then ran odbcinst -i
-d -f /etc/odbcinst.ini. The SELECT query over ODBC ran for about 1 hour,
and then died with:
SQLNumResultCols: -1/1; S1000/[unixODBC]No query has been executed with that
handle
One thing I have noticed is that it always runs for about 1 hour (usually
55-59 minutes) before it dies. Is it possible that something is timing out
on the postgreSQL server side, or ODBC side? I really appreciate the help
with this, if you have any other advice, I'll be glad to give it a try. I
did research timeouts on the postgreSQL Server end, but it seemed to
indicate that the default is for it not to time out, and I haven't modified
anything in postgresql.conf except to have the system listen on 5432.
Regards,
Tom
--
View this message in context: http://postgresql.1045698.n5.nabble.com/ODBC-SELECT-Timeout-tp5756490p5757210.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.