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 22:07:17 |
Message-ID: | e154a28a-81c7-0e2c-cd75-39c24ac20931@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Igor,
On 2017/07/30 22:11, Igor Korot wrote:
> Hi, Hiroshi,
>
> On Sun, Jul 30, 2017 at 8:06 AM, Inoue, Hiroshi
> <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>> 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.
> Yes, that worked.
> No more errors.
>
> Thank you.
>
> Now, shouldn't it be the default when install sinceing the driver?
The default for UseServerSidePrepare was changed to 1 in version 09.03.0100.
regards,
Hiroshi Inoue
> Or this option should come from the DM?
>
>> regards,
>> Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2017-07-30 23:26:19 | Re: HY0000 on SQLDescribeParam |
Previous Message | Igor Korot | 2017-07-30 13:11:21 | Re: HY0000 on SQLDescribeParam |