Re: [ODBC] ODBC for Mac OS

Hi Sean-san.

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>

> On Monday 26 March 2007 21:56, Hiroshi Saito wrote:
>> Hi Sean Davis-san.
>>
>> I am wishing this to help you.
>> Thanks!
>>
>> Regards,
>> Hiroshi Saito
>
> Thank you very much, Hiroshi, for the quick response. That change does appear
> to have fixed the SSL problem. However, there are other problems. I have
> attached the entire config.log and make output, but here is the last part of
> the make output:
>
> 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/execut
> e.o .libs/lobj.o .libs/win_md5.o .libs/misc.o .libs/options.o .libs/pgtypes.o .l
> ibs/psqlodbc.o .libs/qresult.o .libs/results.o .libs/socket.o .libs/parse.o .lib
> s/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/in
> fo30.o .libs/mylog.o .libs/odbcapi30w.o .libs/odbcapiw.o .libs/win_unicode.o -L
> /usr/local/pgsql/lib -lssl -lcrypto
> /usr/bin/ld: Undefined symbols:

Uga...As for it, the link is generated as follows if original.

gcc -shared .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/usr/local/lib -L/usr/local/pgsql/lib -lpq -lpthread /usr/local/lib/libodbcinst.so -lssl -lcrypto -ldl
-Wl,-soname -Wl,psqlodbcw.so -o .libs/psqlodbcw.so

Umm, What result does your pg_config obtain?

> _CONNLOCK_ACQUIRE
> _CONNLOCK_RELEASE
> _INIT_CONNLOCK
> _PQcancel
> _PQerrorMessage
> _PQfinish
> _PQfreeCancel
> _PQgetCancel
> _PQgetssl
> _PQprotocolVersion
> _PQserverVersion
> _PQsocket
> _PQstatus
> _PQuser
> _SQLGetPrivateProfileString
> _SQLWritePrivateProfileString
> _PQconnectdb
> collect2: ld returned 1 exit status
> make[1]: *** [psqlodbcw.la] Error 1
> make: *** [all] Error 2
>

Ahh, It seems to obtain pthread and libpq.

> Still more linker issues, it appears. I don't think it is just my machine--I
> tried this on a couple of machines with the same results.
>
> Sean
>