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-18 16:56:38 |
Message-ID: | 1247936198.4335.5.camel@supermule.opasia.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
#ServerSidePrepare = Yes
UseServerSidePrepare = Yes
And the odbcinst.ini looks like:
[postgreodbc]
Description = PostgreSQL ODBC driver
Driver = /usr/lib/odbc/psqlodbcw.so
#Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
UsageCount = 2
Do anybody have an idea of why I only see VarChar when calling
SQLDescribeParam(..) ?
Or any pointers to how I can debug the problem.
I am running on Debian Linux (Lenny) using psqlodbc version
(1:08.03.0200-1) (see
http://packages.debian.org/source/lenny/psqlodbc ).
Regards,
Mads Lindstrøm
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2009-07-19 04:23:55 | Re: Any plans to support SQLDescribeParam (and friends) ? |
Previous Message | Lothar Behrens | 2009-07-18 12:58:22 | SQLForeignKey does not work |