FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Hi,
>   I am trying a tsql connection from HP-UX to SQL*Server 2000 
> on Windows XP and get the following error - 
>  
> tsql -H xxx.xxx.xxx -p 1433  -U salocale is "C C C C C 
> C"locale charset is "roman8"Password:Msg 20009, Level 9, 
> State 0, Server OpenClient, Line 0Server is unavailable or 
> does not exist.There was a problem connecting to the server
> I can ping and telnet the address xxx.xxx.xxx
>  
> /usr/local/etc# telnet xxx.xxx.xxx 1433Trying...Connected to 
> xxx.xxx.xxx.Escape character is '^]'.
>  
> After setting TDSDUMP the log file shows - 
>  
> util.c:288:Starting log file for FreeTDS 0.64        on 
> 2008-02-11 11:54:31 with debug flags 0x4fff.iconv.c:195:names 
> for ISO-8859-1: iso81iconv.c:195:names for UTF-8: 
> UTF-8iconv.c:195:names for UCS-2LE: (null)iconv.c:195:names 
> for UCS-2BE: ucs2iconv.c:361:iconv to convert client-side 
> data to the "roman8" character 
> seticonv.c:514:tds_iconv_info_init: converting 
> "ROMAN8"->"UCS-2LE"net.c:168:Connecting to xxx.xxx.xxx port 
> 1433.net.c:256:connect error: Not ownerutil.c:119:Changing 
> query state from IDLE to DEADtoken.c:2252:tds_client_msg: 
> #20009: "Server is unavailable or does not exist.".  
> Connection state is now 4.mem.c:519:tds_free_all_results()
> Any suggestions ?  I couldn't find anything on the web to help.
>  
> Regards,
> Mike

I just realized what's the real problem !!!

in /usr/include/sys/socket.h I have

typedef size_t socklen_t;
...
#if defined(_XOPEN_SOURCE_EXTENDED) && !defined(_KERNEL_BUILD)
...
   extern int getsockopt __((int, int, int, void *, socklen_t *));
...

#else  /* !_XOPEN_SOURCE_EXTENDED*/
...
   extern int getsockopt __((int, int, int, void *, int *));

so getsockopt is defined differently if _XOPEN_SOURCE_EXTENDED is
defined... however is defined in different ABI !!!
This means that if you use wrong type (size_t* instead of int*) function
bahave differently... Well int* is correct cause I have tested that
using int* correctly set error...

Which hp-ux version you have? I have an old 11.00 version... can you
post your /usr/include/sys/socket.h (please post it privately!)

freddy77