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

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

From: Mads Lindstrøm <mads_lindstroem(at)yahoo(dot)dk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Any plans to support SQLDescribeParam (and friends) ?
Date: 2009-07-19 06:02:14
Message-ID: 1247983334.4343.2.camel@supermule.opasia.dk (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Hiroshi,

Hiroshi Inoue wrote:
> >> 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
> 

Same results with Protocol = 7.4


Regards,

Mads

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2009-07-20 08:11:23
Subject: [ psqlodbc-Bugs-1001999 ] PSQLODBC folds identifiers to lower case, causing Excel (MS Query) to fail.
Previous:From: Hiroshi InoueDate: 2009-07-19 04:23:55
Subject: Re: Any plans to support SQLDescribeParam (and friends) ?

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