Thread: [ODBC] HY0000 on SQLDescribeParam

[ODBC] HY0000 on SQLDescribeParam

From

Igor Korot

Date:

30 July 2017, 11:01:19

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?

Re: [ODBC] HY0000 on SQLDescribeParam

From

"Inoue, Hiroshi"

Date:

30 July 2017, 18:06:58

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

Re: [ODBC] HY0000 on SQLDescribeParam

From

Igor Korot

Date:

30 July 2017, 19:11:21

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
>

Re: [ODBC] HY0000 on SQLDescribeParam

From

"Inoue, Hiroshi"

Date:

31 July 2017, 04:07:17

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@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 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

Re: [ODBC] HY0000 on SQLDescribeParam

From

Igor Korot

Date:

31 July 2017, 05:26:19

Hi, Hiroshi,

On Sun, Jul 30, 2017 at 6:07 PM, Inoue, Hiroshi
<h-inoue@dream.email.ne.jp> wrote:
> 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@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 install sinceing the driver?
>
>
> The default for UseServerSidePrepare was changed to 1 in version 09.03.0100.

Is there a way to set it to 1 thru the ODBC API?

Thank you.

>
> regards,
> Hiroshi Inoue
>
>
>> Or this option should come from the DM?
>>
>>> regards,
>>> Hiroshi Inoue

Re: [ODBC] HY0000 on SQLDescribeParam

From

"Inoue, Hiroshi"

Date:

31 July 2017, 08:47:47

Hi Igor,

On 2017/07/31 8:26, Igor Korot wrote:
> Hi, Hiroshi,
>
> On Sun, Jul 30, 2017 at 6:07 PM, Inoue, Hiroshi
> <h-inoue@dream.email.ne.jp> wrote:
>> 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@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 install sinceing the driver?
>>
>> The default for UseServerSidePrepare was changed to 1 in version 09.03.0100.
> Is there a way to set it to 1 thru the ODBC API?

If you call SQLDriverConnect() to connect DB, you can use connection
strings like

     SQLDriverConnect(hdbc, NULL,

"DSN=xxxxxxxx;........;UseServerSidePrepare=1;.......",

                 cbConnStrIn,  szConnStrOut, cbConnStrOutMax,
pcbConnStrOut, fDriverCompletion);

regards,
Hiroshi Inoue

>
> Thank you.
>
>> regards,
>> Hiroshi Inoue
>>
>>
>>> Or this option should come from the DM?
>>>
>>>> regards,
>>>> Hiroshi Inoue

Re: [ODBC] HY0000 on SQLDescribeParam

From

Igor Korot

Date:

31 July 2017, 09:02:55

On Sun, Jul 30, 2017 at 10:47 PM, Inoue, Hiroshi
<h-inoue@dream.email.ne.jp> wrote:
> Hi Igor,
>
>
> On 2017/07/31 8:26, Igor Korot wrote:
>>
>> Hi, Hiroshi,
>>
>> On Sun, Jul 30, 2017 at 6:07 PM, Inoue, Hiroshi
>> <h-inoue@dream.email.ne.jp> wrote:
>>>
>>> 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@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 install sinceing the driver?
>>>
>>>
>>> The default for UseServerSidePrepare was changed to 1 in version
>>> 09.03.0100.
>>
>> Is there a way to set it to 1 thru the ODBC API?
>
>
> If you call SQLDriverConnect() to connect DB, you can use connection strings
> like
>
>     SQLDriverConnect(hdbc, NULL,
>
> "DSN=xxxxxxxx;........;UseServerSidePrepare=1;.......",
>
>                 cbConnStrIn,  szConnStrOut, cbConnStrOutMax, pcbConnStrOut,
> fDriverCompletion);

Understood.

Thx.

>
> regards,
> Hiroshi Inoue
>
>
>>
>> Thank you.
>>
>>> regards,
>>> Hiroshi Inoue
>>>
>>>
>>>> Or this option should come from the DM?
>>>>
>>>>> regards,
>>>>> Hiroshi Inoue