ODBC SELECT Timeout

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
FileUsage               = 1
UsageCount              = 2

I'm have the 64 bit drivers installed and it sees those okay.  Thanks for
any help or a point in the right direction.  I'm just starting to really dig
into postgreSQL, so do not know much quite yet.

Regards,
Tom



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