Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

In response to

Responses

pgsql-odbc by date

Next:From: Mads LindstrømDate: 2009-07-19 06:02:14
Subject: Re: Any plans to support SQLDescribeParam (and friends) ?
Previous:From: Mads LindstrømDate: 2009-07-18 16:56:38
Subject: Re: Any plans to support SQLDescribeParam (and friends) ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group