Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?

>>>>> Hiroshi Inoue writes:

Hiroshi> How did you build the driver ?
Hiroshi> Did you link odbcapi30.o, pgapi30.o and info30.o ?

Yes.  Initially I didn't, and got unresolved symbols.

What I did was:
 * check things out from CVS
 * update by libtool, aclocal, etc to the versions specified
   in the README.unix file
 * Issue the following commands
    psqlodbc % cp /usr/share/aclocal/libtool.m4 .
    psqlodbc % aclocal -I . -I $PGSRC/config
    (PGSRC points to a checkout of the PostgreSQL 7.3 sources)
    psqlodbc % ./configure --prefix=/tmp --with-unixodbc
    edit config.h and add the line
     #define ODBCVER 0x351
     at the end of it
    make install

Nick Gorham, maintainer of unixODBC, thinks the problem is in
psqlodbc; I tend to agree although I'm not sure I understand
what's going on.  I got psqlodbc to spit out reams of logging
and debugging data, which I can send you, if you think it'll help.

The upshot right now is that in PGAPI_ColAttributes, the call
is falling through to the default case and raising an error;
it should return the value 19, which corresponds to the PG Type
"Name".

As I said; we've got this driver running fine under Windows
as a ODBC V3. driver.

I'm happy to be your remote debugger and to try things (or patches)
if you have any suggestions.

--
            Alain Picard
            Memetrics