Re: ODBC problem with local PostgreSQL 8.1 DBMS - Mailing list pgsql-odbc

From Nardmann, Heiko
Subject Re: ODBC problem with local PostgreSQL 8.1 DBMS
Date
Msg-id 200703121633.34983.heiko.nardmann@secunet.com
Whole thread Raw
In response to Re: ODBC problem with local PostgreSQL 8.1 DBMS  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
Am Donnerstag, 1. März 2007 17:01 schrieb Ludek Finstrle:
> > I have a problem with connections to a PostgreSQL 8.1 system. My locally
> > running application does about a few hundred SELECTs. During these
> > SELECTs at a random point one SELECT (not even the same) fails always.
> > The failing appears as some sort of Windows exception which I cannot
> > details of because my C++ application catches this exception only by
> > 'catch (...)'. Any other possible exception class is caught before and
> > therefore not candidate for this special exception.
>
> What psqlodbc version are you using? What is the connection string?
> Could you provide us the common log output?
>
> Regards,
>
> Luf
>
> P.S. I'm going to be on holiday next week. I hope someone else will help
>      you.

In the meanwhile we solved the problem. The problem was that the ODBC
definition had 'Debug' option set to '1' which seems to create some overhead
which leads to either timing issues or too much data. I'm using OTL for
accessing ODBC - maybe it is an issue there.

--
Heiko Nardmann

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Next
From: "Gary Greenberg"
Date:
Subject: Re: [JDBC] Error while retrieving generated keys