ODBC on MacOS X

I have downloaded and installed PostgreSQL 8.01 on my Macintosh with no
problems, but want to install ODBC too in order to make useful user
interfaces. Consequently I have ODBC from:

http://gborg.postgresql.org/project/psqlodbc/genpage.php?downloads

and since no Macintosh version was available {only Windows}, I downloaded
the source code instead. But it simply doesn¹t work.

My Macintosh runs MacOS X 10.3.8, a BSD UNIX system.

And a listing of what happens in the shell:

G4:~/psqlodbc per$ ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking dependency style of gcc... gcc3
checking for SQLGetPrivateProfileString in -lodbcinst... no
checking for SQLGetPrivateProfileString in -liodbcinst... yes
checking for ODBC version number... 0x0300
checking for strtoul... yes
checking for strtoll... yes
checking for socket in -lsocket... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ANSI C... (cached) none needed
checking dependency style of gcc... (cached) gcc3
checking build system type... powerpc-apple-darwin7.8.0
checking host system type... powerpc-apple-darwin7.8.0
checking for a sed that does not truncate output... /usr/bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... no
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -p
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for fl32... no
checking for af77... no
checking for fort77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for epcf90... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for lf95... no
checking for g95... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
checking the maximum length of command line arguments... 65536
checking command to parse /usr/bin/nm -p output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc static flag works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fno-common
checking if gcc PIC flag -fno-common works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries...
yes
checking dynamic linker characteristics... darwin7.8.0 dyld
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... no
checking whether the g++ linker (/usr/bin/ld) supports shared libraries...
yes
checking for g++ option to produce PIC... -fno-common
checking if g++ PIC flag -fno-common works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries...
yes
checking dynamic linker characteristics... darwin7.8.0 dyld
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for dlopen in -ldl... (cached) yes
checking whether a program can dlopen itself... (cached) yes
checking whether a statically linked program can dlopen itself... (cached)
yes
appending configuration tag "F77" to libtool
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking for uint8... no
checking for int timezone... no
checking for long... yes
checking size of long... 4
checking for long long... yes
checking for an ANSI C-conforming const... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config.h
config.status: executing depfiles commands
G4:~/psqlodbc per$ make
make all-am
if /bin/sh ./libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -g
-O2 -MT info.lo -MD -MP -MF ".deps/info.Tpo" \
-c -o info.lo `test -f 'info.c' || echo './'`info.c; \
then mv -f ".deps/info.Tpo" ".deps/info.Plo"; \
else rm -f ".deps/info.Tpo"; exit 1; \
fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT info.lo -MD -MP -MF
.deps/info.Tpo -c info.c -fno-common -DPIC -o .libs/info.o
In file included from info.c:19:
psqlodbc.h:46:23: sqlucode.h: No such file or directory
In file included from info.c:19:
psqlodbc.h:326: error: parse error before '*' token
psqlodbc.h:327: error: parse error before '*' token
psqlodbc.h:328: error: parse error before "SQLWCHAR"
info.c: In function `PGAPI_GetInfo':
info.c:752: error: `SQLWCHAR' undeclared (first use in this function)
info.c:752: error: (Each undeclared identifier is reported only once
info.c:752: error: for each function it appears in.)
info.c:757: error: parse error before ')' token
info.c:757: error: parse error before ')' token
make[1]: *** [info.lo] Error 1
make: *** [all] Error 2
G4:~/psqlodbc per$

--
Per Erik Rønne, MSc
Frederikssundsvej 308B, DK-2700 Brønshøj
Telephone & fax 38 89 00 16, mobile 28 23 09 92
Denmark