Re: Bad SQL generated by application

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: Curtis Galloway <curtisg(at)curtisg(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Bad SQL generated by application
Date: 2002-01-15 09:16:56
Message-ID: Pine.LNX.4.21.0201151115020.17333-100000@nanu.visionforisrael.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


On Mon, 14 Jan 2002, Curtis Galloway wrote:
>
> I am trying to figure out whether the problem is in the SQL the
> application generates, or whether the ODBC driver is generating the SQL.
> I can't tell from looking at the ODBC log which is the case.
>
> I am relatively new to Postgres and ODBC, although I have a lot of
> experience with Oracle. Can anyone give me some advice for debugging
> this problem?

Turn on debugging ;) Really, turn on logging of SQL commands in the
backend and look there so you can see how the backend gets the SQL (from
the ODBC driver).

-Cedar

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-01-16 11:15:58 Re: Error Writing/Reading Encrypted Values
Previous Message cnliou 2002-01-15 07:27:05 Re: Error Writing/Reading Encrypted Values