Skip to Content.
Sympa Menu

freetds - [freetds] Adaptive Server connection failed - FreeTDS v0.82 and MSSQL 2008

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <Joshua.Moore AT parc.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Adaptive Server connection failed - FreeTDS v0.82 and MSSQL 2008
  • Date: Mon, 26 Nov 2012 21:02:44 +0000

My client is running Ubuntu 10.04 and FreeTDS v0.82. I am trying to connect
to a MSSQL server 2008 running on Windows server 2008r2. Last Thursday
(11/15) I applied the latest patches from Microsoft and I am no longer able
to connect. I have both Python and PERL code leveraging FreeTDS.

client.parc.xerox.com% tsql -S dbhost.parc.com -U pcweb
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
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

I've tried changing the tds version to 4.2, 7.0, 7.1, 7.2, 8.0 to no avail.
Any idea what might have changed - presumably on SQL Server - and how to fix
it? I have another client running CentOS with PHP code. Changing my DSNless
connection string on the CentOS box running freetds v0.91 to specify TDS
version 7.2 fixed the problem on CentOS.

Thanks!



Here are some log files

root@client:/etc/freetds# more /tmp/freetds.log
09:52:36.610127 28113 (log.c:190):Starting log file for FreeTDS 0.82
on 2012-11-20 09:52:36 with debug flags 0xffff.
09:52:36.610202 28113 (iconv.c:197):names for ISO-8859-1: ISO-8859-1
09:52:36.610211 28113 (iconv.c:197):names for UTF-8: UTF-8
09:52:36.610214 28113 (iconv.c:197):names for UCS-2LE: UCS-2LE
09:52:36.610217 28113 (iconv.c:197):names for UCS-2BE: UCS-2BE
09:52:36.610220 28113 (iconv.c:363):iconv to convert client-side data to the
"UTF-8" ch
aracter set
09:52:36.610238 28113 (iconv.c:516):tds_iconv_info_init: converting
"UTF-8"->"UCS-2LE"
09:52:36.610253 28113 (iconv.c:516):tds_iconv_info_init: converting
"ISO-8859-1"->"UCS-
2LE"
09:52:36.610260 28113 (net.c:210):Connecting to 13.x.xx.xx port 1433 (TDS
version 7.0)
09:52:36.610335 28113 (net.c:264):tds_open_socket: connect(2) returned
"Operation now i
n progress"
09:52:36.610624 28113 (net.c:303):tds_open_socket() succeeded
09:52:36.610638 28113 (util.c:162):Changed query state from DEAD to IDLE
09:52:36.610644 28113 (login.c:735):quietly sending TDS 7+ login packet
09:52:36.610674 28113 (token.c:312):tds_process_login_tokens()
09:52:36.612042 28113 (util.c:334):tdserror(0x7ac160, 0x7b5b20, 20017, 0)
09:52:36.612064 28113 (util.c:368):tdserror: client library returned
TDS_INT_CANCEL(2)
09:52:36.612068 28113 (util.c:389):tdserror: returning TDS_INT_CANCEL(2)
09:52:36.612082 28113 (util.c:162):Changed query state from IDLE to DEAD
09:52:36.612087 28113 (token.c:316):looking for login token, got 0()
09:52:36.612092 28113 (token.c:108):tds_process_default_tokens() marker is 0()
09:52:36.612099 28113 (token.c:111):leaving tds_process_default_tokens()
connection dea
d
09:52:36.612103 28113 (util.c:334):tdserror(0x7ac160, 0x7b5b20, 20002, 0)
09:52:36.612110 28113 (util.c:368):tdserror: client library returned
TDS_INT_CANCEL(2)
09:52:36.612114 28113 (util.c:389):tdserror: returning TDS_INT_CANCEL(2)
09:52:36.612119 28113 (mem.c:563):tds_free_all_results()


root@client:/etc/freetds# more /tmp/tdsconfig.log.28113
log.c:190:Starting log file for FreeTDS 0.82
on 2012-11-20 09:52:36 with debug flags 0x4fff.
config.c:172:Getting connection information for [dbhost.parc.com].
config.c:181:Attempting to read conf files.
config.c:310:... $FREETDSCONF not set. Trying $FREETDS/etc.
config.c:323:... $FREETDS not set. Trying $HOME.
config.c:253:Found conf file '/etc/freetds/freetds.conf' (default).
config.c:398:Looking for section global.
config.c:455: Found section global.
config.c:458:Got a match.
config.c:479: tds version = '8.0'
config.c:479: port = '1433'
config.c:479: dump file = '/etc/freetds/tmp.log'
config.c:479: debug flags = '0xffff'
config.c:479: timeout = '10'
config.c:479: connect timeout = '10'
config.c:479: text size = '64512'
config.c:455: Found section dbhost.parc.com.
config.c:455: Found section dbhost.
config.c:469: Reached EOF
config.c:398:Looking for section dbhost.parc.com.
config.c:455: Found section global.
config.c:455: Found section dbhost.parc.com.
config.c:458:Got a match.
config.c:479: host = 'dbhost.parc.com'
config.c:508:Found host entry dbhost.parc.com.
config.c:512:IP addr is 13.x.xx.xx.
config.c:479: port = '1433'
config.c:479: tds version = '7.0'
config.c:455: Found section dbhost.
config.c:469: Reached EOF
config.c:257:Success: [dbhost.parc.com] defined in /etc/freetds/freetds.conf.
config.c:619:Setting 'dump_file' to '/tmp/freetds.log' from $TDSDUMP.
config.c:558:tds_config_login: client_charset is UTF-8.
config.c:195:Final connection parameters:
config.c:196: server_name = dbhost.parc.com
config.c:197: port = 1433
config.c:198: major_version = 7
config.c:199: minor_version = 0
config.c:200: block_size = 0
config.c:201: language = us_english
config.c:202: server_charset = ANSI_X3.4-1968
config.c:203: connect_timeout = 10
config.c:204: client_host_name = client.parc.xerox.com
config.c:205: app_name = TSQL
config.c:206: user_name = pcweb
config.c:209: library = TDS-Library
config.c:210: bulk_copy = 0
config.c:211: suppress_language = 0
config.c:212: encrypt level = 0
config.c:213: query_timeout = 10
config.c:216: client_charset = UTF-8
config.c:217: ip_addr = 13.xx.xx.xx
config.c:218: instance_name =
config.c:219: database =
config.c:220: dump_file = /tmp/freetds.log
config.c:221: debug_flags = ffff
config.c:222: text_size = 64512
config.c:223: broken_dates = 0
config.c:224: broken_money = 0
config.c:225: emul_little_endian = 0





Archive powered by MHonArc 2.6.24.

Top of Page