Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 18ED19FB1F1;
	Mon, 26 Mar 2007 07:36:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 19405-03; Mon, 26 Mar 2007 07:36:10 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from nihrelayxway2.hub.nih.gov (mailfwd.nih.gov [128.231.90.107])
	by postgresql.org (Postfix) with ESMTP id 8E9DC9FB2B2;
	Mon, 26 Mar 2007 07:36:10 -0300 (ADT)
Received: from pressa.nci.nih.gov ([137.187.209.230])
	by nihrelayxway2.hub.nih.gov with ESMTP; 26 Mar 2007 06:36:09 -0400
X-IronPortListener: NIH_Relay
X-SBRS: None
X-IronPort-AV: i="4.14,329,1170651600";
	d="scan'208"; a="282988218:sNHT13900480"
From: Sean Davis <sdavis2@mail.nih.gov>
Organization: NIH
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: ODBC for Mac OS
Date: Mon, 26 Mar 2007 06:36:09 -0400
User-Agent: KMail/1.9.5
Cc: pgsql-interfaces@postgresql.org,
 pgsql-odbc@postgresql.org
References: <4606AC15.90406@mail.nih.gov> <2381.1174877131@sss.pgh.pa.us>
In-Reply-To: <2381.1174877131@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200703260636.09171.sdavis2@mail.nih.gov>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/35
X-Sequence-Number: 6476

On Sunday 25 March 2007 22:45, Tom Lane wrote:
> Sean Davis <sdavis2@mail.nih.gov> writes:
> > I'm trying to compile psqlodbc-08.02.0200 for Mac OS.  I'm getting the
> > following when I try to do that:
> >
> > gcc  -o .libs/psqlodbcw.so -bundle  .libs/info.o .libs/bind.o
> > .libs/columninfo.o .libs/connection.o .libs/convert.o .libs/drvconn.o
> > .libs/environ.o .libs/execute.o .libs/lobj.o .libs/win_md5.o
> > .libs/misc.o .libs/options.o .libs/pgtypes.o .libs/psqlodbc.o
> > .libs/qresult.o .libs/results.o .libs/socket.o .libs/parse.o
> > .libs/statement.o .libs/tuple.o .libs/dlg_specific.o .libs/loadlib.o
> > .libs/multibyte.o .libs/odbcapi.o .libs/descriptor.o .libs/odbcapi30.o
> > .libs/pgapi30.o .libs/info30.o .libs/mylog.o .libs/odbcapi30w.o
> > .libs/odbcapiw.o .libs/win_unicode.o  -L/Users/sdavis/local/pgsql/lib
> > -lpgport -lz -lreadline -lresolv -ldl -lm -lpq
> > /usr/bin/ld: Undefined symbols:
> > _CONNLOCK_ACQUIRE
> > _CONNLOCK_RELEASE
> > _INIT_CONNLOCK
> > _SSL_get_error
> > _SSL_read
> > _SSL_write
> > _SQLGetPrivateProfileString
> > _SQLWritePrivateProfileString
> > collect2: ld returned 1 exit status
> > make[1]: *** [psqlodbcw.la] Error 1
>
> Darwin is pickier than most other OSes about requiring that all symbols
> referenced by a shared library be defined in one or another of the
> shared libraries listed when it's linked.  In this case the link command
> is clearly missing a -l switch for OpenSSL, and probably a couple other
> things.  ODBC guys, can you fix this?

Thanks, Tom.  I'll see what I can work out here, but I'm a bit out of my 
league.

Sean