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] <[hidden email]> 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
