Re: [ODBC] ODBC for Mac OS

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
>