>>>>> 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
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
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.
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2003-02-05 00:37:06|
|Subject: Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?|
|Previous:||From: Michael Calabrese||Date: 2003-02-04 22:05:32|
|Subject: ODBC Performance Question|