SQLDescribeParam / SUPPORT_DESCRIBE_PARAM

From: Marten Lehmann <lehmann(at)cnm(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLDescribeParam / SUPPORT_DESCRIBE_PARAM
Date: 2011-11-09 01:42:52
Message-ID: 4EB9DA9C.7040800@cnm.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I noticed that unixODBC logs IM001 SQL_ERRORs for SQLDescribeParam in
its tracefile. Actually, I first noticed the problem when I tried to use
a prepared statement in PHP 5.3.8 with a PostgreSQL 9.1 database and I
got error messages at odbc_execute() due to the SQLDescribeParam error.

First I thought that the problem is in PHPs ODBC extension because it
worked fine back in PHP-5.3.3. But digging into the sources of PHP I
found out, that the return value of SQLDescribeParam simply wasn't
validated before 5.3.5 (and there as no 5.3.4 release), but it returned
an IM001 SQL_ERROR ever since.

So following the chain I looked at the source of psqlodbc and noticed,
that the library is prepared for a database connection that supports
SQLDescribeParam and this is verified by SUPPORT_DESCRIBE_PARAM().

But what does it depend on, whether the connection supports it? psqlodbc
is for PostgreSQL only. I built the latest PostgreSQL library, compiled
the latest psqlodbc against it and SQLDescribeParam still threw the
IM001 SQL_ERROR.

As a quick fix just created a patch for PHP for my internal use, which
removes checking of the return values of SQLDescribeParam. But that
seems very odd. I'd really like to understand what's behind this issue.

Kind regards
Marten Lehmann

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2011-11-09 03:48:44 Re: SQLDescribeParam / SUPPORT_DESCRIBE_PARAM
Previous Message Dave Page 2011-11-08 08:52:44 Re: 9.1 driver status