Re: [HACKERS] Single row fetch from backend

> I had a look at the ODBC interface for Postgres, yet could not get it to work
> on my Linux RH5.0 machine. When linking with libpsqlodbc.a I get the following
> cc -I $PGHOME/include/iodbc testpgodbc.c $PGHOME/lib/libpsqlodbc.a -lm
> libpsqlodbc.a(psqlodbc.o): In function `_init':
> psqlodbc.o(.text+0x0): multiple definition of `_init'
> /usr/lib/crti.o(.init+0x0): first defined here
> libpsqlodbc.a(psqlodbc.o): In function `_fini':
> psqlodbc.o(.text+0x30): multiple definition of `_fini'
> /usr/lib/crti.o(.fini+0x0): first defined here
> Looks like I am not doing the correct thing, yet don't know what else to do.

Are you building in the Postgres tree using the make system? If you
aren't, try either:

1) configure --with-odbc
cd interfaces/odbc
make install

or

2) Unpack the "standalone" odbc file from ftp://postgresql.org/pub/
and configure then make it in a separate directory.

I've left out a few steps; read the html or postscript docs in the
chapter on ODBC for complete details, and let us know what didn't
work.

I've built the ODBC interface on RH5.2, and probably had used an
earlier version of RH when I was working out the port with the other
developers.

Good luck.

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California