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

Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?

From: Alain Picard <Alain(dot)Picard(at)memetrics(dot)com>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Alain Picard <Alain(dot)Picard(at)memetrics(dot)com>,Nick Gorham <nick(at)easysoft(dot)com>,Peter Harvey <pharvey(at)codebydesign(dot)com>, pgsql-odbc(at)postgresql(dot)org,claudio(dot)natoli(at)memetrics(dot)com
Subject: Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?
Date: 2003-02-04 22:41:33
Message-ID: 15936.16797.475953.234542@outback.memetrics.local (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
>>>>> 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 

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

In response to


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2003-02-05 00:37:06
Subject: Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?
Previous:From: Michael CalabreseDate: 2003-02-04 22:05:32
Subject: ODBC Performance Question

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