Thread: psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X

Okay, not much traffic on the postgres.odbc group so I'll try here.

I'm trying to get postgresql and excel x to talk over odbc and a cup of
tea but the psql odbc driver is not compiling for me today.
I used configure with --with-iodbc option.

this is the standard out output from the make process:
make  all-am
/bin/sh ./libtool --mode=link gcc  -g -O2   -o psqlodbc.la -rpath
/usr/local/lib -module -no-undefined -avoid-version info.lo bind.lo
columninfo.lo connection.lo convert.lo drvconn.lo environ.lo execute.lo
lobj.lo win_md5.lo misc.lo options.lo pgtypes.lo psqlodbc.lo qresult.lo
results.lo socket.lo parse.lo statement.lo tuple.lo tuplelist.lo
dlg_specific.lo odbcapi.lo multibyte.lo gpps.lo odbcapi30.lo pgapi30.lo
info30.lo -liodbcinst
rm -fr .libs/psqlodbc.la .libs/psqlodbc.* .libs/psqlodbc.*
gcc -r -keep_private_externs -nostdlib -o .libs/psqlodbc.so-master.o
info.lo bind.lo columninfo.lo connection.lo convert.lo drvconn.lo
environ.lo execute.lo lobj.lo win_md5.lo misc.lo options.lo pgtypes.lo
psqlodbc.lo qresult.lo results.lo socket.lo parse.lo statement.lo
tuple.lo tuplelist.lo dlg_specific.lo odbcapi.lo multibyte.lo gpps.lo
odbcapi30.lo pgapi30.lo info30.lo && gcc -bundle  -o .libs/psqlodbc.so
.libs/psqlodbc.so-master.o  -L/usr/local/lib -liodbcinst -lc
ld: Undefined symbols:
_CFBundleCopyExecutableURL
_CFBundleCopyResourceURL
_CFBundleGetBundleWithIdentifier
_CFRelease
_CFStringGetCString
_CFURLCopyFileSystemPath
___CFStringMakeConstantString

I found a similar reference to this problem here:

http://www.google.co.jp/search?q=cache:zLM4PQ_fgWoJ:archives.postgresql.org/pgsql-odbc/2004-04/msg00028..php++psqlodbc+iodbc+MAC+os+X&hl=ja&start=1&ie=UTF-8&inlang=ja
but archives.postgresql.org seems to be down and I couldn't access the
google cache for the response.
I'd appreciate your help on the topic.

Tim Perkins wrote:
> Okay, not much traffic on the postgres.odbc group so I'll try here.

There would have been traffic if you had actually posted there.

> I'm trying to get postgresql and excel x to talk over odbc and a cup
> of tea but the psql odbc driver is not compiling for me today.
> I used configure with --with-iodbc option.

To compile it, run

./configure --with-iodbc LDFLAGS='-Wl,-framework,Carbon'

There are, however, rumours that it still doesn't run well.  You're in
unchartered territory.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/