From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Mads Lindstrøm <mads_lindstroem(at)yahoo(dot)dk> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Any plans to support SQLDescribeParam (and friends) ? |
Date: | 2009-07-19 04:23:55 |
Message-ID: | 4A629FDB.4070903@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mads Lindstrøm | 2009-07-19 06:02:14 | Re: Any plans to support SQLDescribeParam (and friends) ? |
Previous Message | Mads Lindstrøm | 2009-07-18 16:56:38 | Re: Any plans to support SQLDescribeParam (and friends) ? |