FreeTDS Development Group

[ikorot AT earthlink.net]

Hi, Zhouhua,


-----Original Message-----
>From: Zhouhua Li <zhouhua.li AT gmail.com>
>Sent: Jul 28, 2010 2:22 PM
>To: ikorot AT earthlink.net, FreeTDS Development Group 
><freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] tsql:Adaptive Server connection failed with MinGW 
>Build         of FreeTDS 0.83
>
>Yes, I can ping/telnet to the machine/port without problem. 

OK.

>All
>machines sit in an intranet so there is no firewall between them.

OK.

> 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.

What is you configure options?
Can you post some code that you are using to connect to the DB?

Thank you.

>
>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
>>