Re: Any plans to support SQLDescribeParam (and friends) ?

Hi Mads,

Mads Lindstrøm wrote:
> Hi Hiroshi,
>
> Thank you for the reply.
>
>
> Hiroshi Inoue wrote:
>
>> Mads Lindstrøm wrote:
>>> Hi
>>>
>>> Previously PsqlODBC did not support SQLDescribeParam (and friends), as
>>> the PostgreSQL backend/frontend protocol did not offer the necessary
>>> support to implement these functions [1]. Or at least, that is how I
>>> understand it.
>>>
>>> But with protocol version 3, it should be possible to implement
>>> SQLDescribeParam[2].
>>>
>>> Thus my question, is there any plans to support SQLDescribeParam (and
>>> friends) ?
>> You can call SQLDescribeParam() with the current driver when you
>> check the 7.4+ Protocol option and the Server side prepare option.
>>
>> regards,
>> Hiroshi Inoue
>>
>
> Yes, I can call SQLDescribeParam(..), but it always return VarChar, on
> SMALLINT, INTEGER, BIGINT and DECIMAL parameters. So I guess I am doing
> something wrong.
>
> My odbc.ini looks like:
>
> [MetaHDBC_PQ_DSN]
> Description           = PostgreSQL ODBC
> Driver                = postgreodbc
> Trace                 = No
> TraceFile             =
> Database                = MetaHDBC_DB
> Servername              = localhost
> UserName                = metahdbc
> Password                = foobar
> Port                    = 5432
> Protocol                = 8.3

Could you try to set
    Protocol = 7.4
?

regards,
Hiroshi Inoue