Re: [ODBC] ODBC for Mac OS

["Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>]

Hi Sean Davis-san.

I am wishing this to help you.
Thanks!

Regards,
Hiroshi Saito

Sent: Tuesday, March 27, 2007 10:49 AM
Subject: [COMMITTERS] psqlodbc - psqlodbc: The lib verification of OpenSSL was added.


> Log Message:
> -----------
> The lib verification of OpenSSL was added. 
> It was confirmed in Linux.
> This might correspond to the problem report of Darwin. 
> from Sean Davis.
> Thanks!
>
> Modified Files:
> --------------
>    psqlodbc:
>        configure.ac (r1.57 -> r1.58)
>        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/configure.ac.diff?r1=1.57&r2=1.58)

----- Original Message ----- 
From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-interfaces(at)postgresql(dot)org>; <pgsql-odbc(at)postgresql(dot)org>
Sent: Monday, March 26, 2007 7:36 PM
Subject: Re: [ODBC] [INTERFACES] ODBC for Mac OS


> On Sunday 25 March 2007 22:45, Tom Lane wrote:
> > Sean Davis <sdavis2(at)mail(dot)nih(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend