Compile errors on Solaris 8 - Mailing list pgsql-odbc

Yes, I am going to be running everything on the solaris 8 machine.  I have, however, answered my own question and
managedget it to compile correctly.  To fix it (in case anyone posts a similar problem in the future, change the
followingin src/Makefile.shlibs 
----
ifeq ($(PORTNAME), solaris)
  shlib                 := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_
VERSION)
  LINK.shared           = $(COMPILER) -G
  ifeq ($(with_gnu_ld), yes)
    LINK.shared         += -Wl,-soname,$(soname)
  else
    LINK.shared         += -Wl,-h,$(soname)
  endif
  SHLIB_LINK            += -lm -lc -lsocket -lnsl
endif
----
The SHLIB_LINK line only contained lm and lc, and lsocket and lnsl needed to be added in order for the unresolved
symbolsto go away. 

I'm now having a different problem, though.
When I run isql to test my configuration with the current driver, I get the following:
----
root@commcon:/usr/local/unixODBC# bin/isql -v test
[unixODBC]Could not connect to the server;
Could not connect to remote socket.
[ISQL]ERROR: Could not SQLConnect
----
and the error logs say...
----
DSN info: DSN=test,server='localhost',port='5432',dbase='test',user='postgres',passwd='test'
          onlyread='No',protocol='6.4',showoid='No',fakeoidindex='No',showsystable='No'
          conn_settings=''
          translation_dll='',translation_option=''
conn = 156040, SQLConnect(DSN='test', UID='postgres', PWD='test')
Global Options: Version='07.01.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
CONN ERROR: func=SQLConnect, desc='Error on CC_connect', errnum=101, errmsg='Could not connect to the server'
            ------------------------------------------------------------
            henv=155016, conn=156040, status=0, num_stmts=16
            sock=162512, stmts=170768, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=-1, reverse=0, errornumber=4, errormsg='Could not connect to remote socket.'
            buffer_in=162560, buffer_out=166664
            buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
----
If anyone knows what might be causing this and how to fix it, then please let me know.

Thanks,
Bill Osmond

 p.s. just so that nobody wonders about the obvious....
# ps -ef | grep postmaster
postgres 25797     1  0 17:09:59 ?        0:00 bin/postmaster -D /usr/local/pgsql/data
so yes it is running

------------------------------------------
On Mon, 21 May 2001 09:36:56 +0300 (IDT), Cedar Cox wrote:
>Please note, you only need to compile odbc here if you are going to use
>odbc on this machine.  If you were planning on using odbc from a windoze
>machine you only need a precompiled driver from the ftp site (or you can
>compile it yourself).
>
>On Wed, 16 May 2001, William Osmond wrote:
>
>> Hi everyone, I'm attempting to compile the odbc interface for postgresql 7.1, and it keeps giving me these
unresolvedsymbol errors.  Any help would be appreciated, as I am admittedly somewhat of a novice with regards to the
solarisenvironment. 
>>
>> ----
>> ar crs libpsqlodbc.a `lorder info.o bind.o columninfo.o connection.o convert.o drvconn.o environ.o execute.o lobj.o
misc.ooptions.o pgtypes.o psqlodbc.o qresult.o results.o socket.o parse.o statement.o gpps.o tuple.o tuplelist.o
dlg_specific.o| tsort` 
>> UX tsort: INFORM: cycle in data
>>     results.o
>>     parse.o
>>     info.o
>> UX tsort: INFORM: cycle in data
>>     psqlodbc.o
>>     dlg_specific.o
>>     convert.o
>>     connection.o
>>     results.o
>>     parse.o
>>     statement.o
>>     bind.o
>> UX tsort: INFORM: cycle in data
>>     socket.o
>>     psqlodbc.o
>>     dlg_specific.o
>>     convert.o
>>     connection.o
>>     results.o
>>     qresult.o
>>     columninfo.o
>> UX tsort: INFORM: cycle in data
>>     socket.o
>>     psqlodbc.o
>>     dlg_specific.o
>>     convert.o
>>     connection.o
>> UX tsort: INFORM: cycle in data
>>     pgtypes.o
>>     psqlodbc.o
>>     dlg_specific.o
>>     convert.o
>> UX tsort: INFORM: cycle in data
>>     psqlodbc.o
>>     dlg_specific.o
>>     misc.o
>> UX tsort: INFORM: cycle in data
>>     dlg_specific.o
>>     psqlodbc.o
>> ranlib libpsqlodbc.a
>> gcc  -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC -G -Wl,-h,libpsqlodbc.so.0 -Wl,-Bsymbolic info.o bind.o
columninfo.oconnection.o convert.o drvconn.o environ.o execute.o lobj.o misc.o options.o pgtypes.o psqlodbc.o qresult.o
results.osocket.o parse.o statement.o gpps.o tuple.o tuplelist.o dlg_specific.o  -lm -lm -lc -Wl,-R/usr/local/pgsql/lib
-olibpsqlodbc.so.0.26 
>> Undefined                       first referenced
>> symbol                             in file
>> socket                              socket.o
>> recv                                socket.o
>> gethostbyname                       socket.o
>> send                                socket.o
>> inet_addr                           socket.o
>> main                                /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/crt1.o
>> connect                             socket.o
>> ld: warning: Symbol referencing errors
>>
>> Thank you in advance,
>> Bill Osmond
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://www.postgresql.org/search.mpl
>>