FreeTDS Development Group

[Zhouhua Li <zhouhua.li AT gmail.com>]

Yes, I can ping/telnet to the machine/port without problem. All
machines sit in an intranet so there is no firewall between them. I
only managed to build libtds.lib and tsql, not any client solutions.
It's my understanding tsql only needs libtds.lib. Please correct me if
I'm wrong. Finally the database I'm trying to connect to is Microsoft
SQL Server not Sybase.

Thank you.

Zhouhua


On Wed, Jul 28, 2010 at 4:20 PM,  <ikorot AT earthlink.net> wrote:
> Hi, Zhouhua,
>
>
> -----Original Message-----
>>From: Zhouhua Li <zhouhua.li AT gmail.com>
>>Sent: Jul 28, 2010 6:42 AM
>>To: freetds AT lists.ibiblio.org
>>Subject: [freetds] tsql:Adaptive Server connection failed with MinGW Build  
>>   of FreeTDS 0.83
>>
>>There was a discussion about a similar topic a few months ago. I can
>>not see what the conclusion is and wonder if somebody can help me. I
>>played with different TDS protocol versions, 7.0 and 8.0, when issuing
>>tsql command. The error and log messages are similar.
>>
>>>>>> Facts:
>>
>>Compiler: MinGW + Msys, gcc version 4.2.1
>>Database: MS SQL Server 2005
>>
>>>>>> Error from tsql command:
>>
>>Msg 20017, Level 9, State -1, Server OpenClient, Line -1
>>Unexpected EOF from the server
>>Msg 20002, Level 9, State -1, Server OpenClient, Line -1
>>Adaptive Server Connection failed
>>There was a problem connecting to the server
>>
>>>>>> log file:
>>
>>log.c:196:Starting log file for FreeTDS 0.83.dev.20100720
>>       on 2010-07-27 22:37:44 with debug flags 0x4fff.
>>iconv.c:337:tds_iconv_open(003D43A8, 1252)
>>iconv.c:312:Using trivial iconv
>>iconv.c:197:local name for ISO-8859-1 is ISO-8859-1
>>iconv.c:197:local name for UTF-8 is UTF-8
>>iconv.c:197:local name for UCS-2LE is UCS-2LE
>>iconv.c:197:local name for UCS-2BE is UCS-2BE
>>iconv.c:365:setting up conversions for client charset "1252"
>>iconv.c:367:preparing iconv for "1252" <-> "UCS-2LE" conversion
>>iconv.c:443:tds_iconv_info_init: client charset name "1252" unrecognized
>>net.c:225:Connecting to 10.1.0.163 port 1433 (TDS version 7.0)
>>net.c:281:tds_open_socket: connect(2) returned "WSAEWOULDBLOCK:
>>Resource temporarily unavailable."
>>net.c:321:tds_open_socket() succeeded
>>util.c:156:Changed query state from DEAD to IDLE
>>login.c:771:quietly sending TDS 7+ login packet
>>token.c:328:tds_process_login_tokens()
>>util.c:331:tdserror(003D42A8, 003D43A8, 20017, 0)
>>util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>>util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>>util.c:156:Changed query state from IDLE to DEAD
>>token.c:337:looking for login token, got  0()
>>token.c:122:tds_process_default_tokens() marker is 0()
>>token.c:125:leaving tds_process_default_tokens() connection dead
>>login.c:462:login packet accepted
>>util.c:331:tdserror(003D42A8, 003D43A8, 20002, 0)
>>util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>>util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>>mem.c:615:tds_free_all_results()
>
> Are you able to connect to the machine/port with telnet?
> Do you running any firewall on the Adaptive Server machine?
> What client solution are you using: ODBC, ct-lib or db-lib?
>
> For an Sybase Adaptive Server you can use TDS 5.0 protocol, but thats not
> really important here. You need to have a connection.
>
> Thank you.
>
>>_______________________________________________
>>FreeTDS mailing list
>>FreeTDS AT lists.ibiblio.org
>>http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>