Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] ODBC for Mac OS

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>,<pgsql-interfaces(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] ODBC for Mac OS
Date: 2007-03-27 11:59:17
Message-ID: 026e01c77067$58a10b00$c701a8c0@wiseknot.local (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
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
>


In response to

Responses

pgsql-odbc by date

Next:From: Sean DavisDate: 2007-03-27 12:17:45
Subject: Re: [ODBC] ODBC for Mac OS
Previous:From: noreplyDate: 2007-03-27 02:47:15
Subject: [ psqlodbc-Bugs-1002767 ] Fatal exception error after running some queries

pgsql-interfaces by date

Next:From: Sean DavisDate: 2007-03-27 12:17:45
Subject: Re: [ODBC] ODBC for Mac OS
Previous:From: jeanie.schwenkDate: 2007-03-27 04:18:56
Subject: pgadmin III 1.6.2 crashes when inserting a row

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group