Re: ODBC problem with local PostgreSQL 8.1 DBMS

From: "Nardmann, Heiko" <heiko(dot)nardmann(at)secunet(dot)com>
To: Ludek Finstrle <luf(at)pzkagis(dot)cz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC problem with local PostgreSQL 8.1 DBMS
Date: 2007-03-12 15:33:30
Message-ID: 200703121633.34983.heiko.nardmann@secunet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Gary Greenberg 2007-03-12 17:46:10 Re: [JDBC] Error while retrieving generated keys
Previous Message noreply 2007-03-12 07:10:22 [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access