Re: Bug report - ODBC Driver - Error 42P18 - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: Bug report - ODBC Driver - Error 42P18
Date
Msg-id 5310BE6C.4080608@vmware.com
Whole thread Raw
In response to Bug report - ODBC Driver - Error 42P18  (Consolity Inc <consolity@outlook.com>)
List pgsql-odbc
On 02/28/2014 06:20 PM, Consolity Inc wrote:
> The PostgreSQL ANSI ODBC driver reports 42P18 - ERROR: could not determine data type of parameter $<n>; when
preparingSQL with an expression of the form: 
> <bound parameter> IS NULL.
> This is a breaking change to existing code that depends on being able to check the NULL-ness of a parameter.
> Behavior is new as of psqlODBC 09.03.0100

The default for UseServerSidePrepare changed in 09.03.0100. Maybe it's
because of that? You can try setting UseServerSidePrepare=0 to get the
old behavior.

I would recommend modifying the query to explicitly cast the parameter,
though. Something like "?::text IS NULL" should work.

- Heikki


pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Bug report - ODBC Driver - Error 42P18
Next
From: Heikki Linnakangas
Date:
Subject: Re: UUID, UUID-OSSP extension, and ODBC issue