Re: HY0000 on SQLDescribeParam

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: HY0000 on SQLDescribeParam
Date: 2017-07-30 12:06:58
Message-ID: 7d65260f-cab1-6ee3-55fc-4344ad0a244a@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Igor,

On 2017/07/30 14:01, Igor Korot wrote:
> Hi, ALL,
> I'm getting an error calling SQLDescribeParam() on PostgreSQL 9.4.
>
> The message obtained by SQLGetDiagRec() reads:
>
> [quote]
> Unfortunately couldn't get this parameter info.
> [/quote]
>
> I'm on OSX 10.8 using iODBC DM.
> The PostgreSQL ODBC driver is not the current one (at least I don't think so).
>
> This same call succeeded with MS SQL Server.
>
> Does anybody have an idea of how to work around this?

Could try to turn on the UseServerSidePrepare option?
i.e set
UseServerSidePrepare = 1
to your odbc.ini file.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2017-07-30 13:11:21 Re: HY0000 on SQLDescribeParam
Previous Message Igor Korot 2017-07-30 05:01:19 HY0000 on SQLDescribeParam