Re: [ODBC] HY0000 on SQLDescribeParam

Поиск
Список
Период
Сортировка
От Igor Korot
Тема Re: [ODBC] HY0000 on SQLDescribeParam
Дата
Msg-id CA+FnnTx9ojhDdmnmVHqCU3rFkQZEp_LUGtNmr-YFc=504NE7Xw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ODBC] HY0000 on SQLDescribeParam  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Ответы Re: [ODBC] HY0000 on SQLDescribeParam  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список pgsql-odbc
Hi, Hiroshi,

On Sun, Jul 30, 2017 at 8:06 AM, Inoue, Hiroshi
<h-inoue@dream.email.ne.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 installing the driver?
Or this option should come from the DM?

>
> regards,
> Hiroshi Inoue
>


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: [ODBC] HY0000 on SQLDescribeParam
Следующее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: [ODBC] HY0000 on SQLDescribeParam