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