Skip to Content.
Sympa Menu

freetds - [freetds] cannot connect with tsql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Agnieszka Figiel <agnieszka AT llp.pl>
  • To: freetds <freetds AT lists.ibiblio.org>
  • Subject: [freetds] cannot connect with tsql
  • Date: Thu, 30 Sep 2010 11:58:47 +0200

Hello,

my first time here, so greetings to all!

I found an old thread by Kevin Reed, regarding connecting to mssql
2000 with tsql, which seems to describe the exact same problem I'm
having with mssql 2008:

https://lists.ibiblio.org/sympa/arc/freetds/2009q1/024223.html

Unfortunately, no solution was posted.

I do not have admistrative access to the mssql instance, but I was
assured the db and firewall were enabled for me to connect from a
specified ip address, and indeed I can telnet to 1433. An additional
requirement is that I need to use encryption, which made me believe
that my connection is failing due to this:

"Encrypted connections to Microsoft SQL Server 2008 using FreeTDS 0.82
do not work. Avoid them. Patches welcome! "

However, my tsql dump looks exactly the same as the original poster's,
and in one of the replies James K. Lowden stated that there's no sign
of encryption problems there. So what else can it be?

I'm using freetds 0.82-4

The relevant portion of freetds.conf:

[rt]
host = [filtered]
port = 1433
tds version = 8.0
client charset = UTF-8
encryption = request

The dump:

TDSDUMP=stderr FREETDSCONF=/tmp/freetds.conf tsql -S rt -U [***] -P
[***] -D [***]

locale is "en_US.UTF-8"
locale charset is "UTF-8"
Default database being set to [***]
log.c:190:Starting log file for FreeTDS 0.82
on 2010-09-30 05:54:57 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:210:Connecting to [***] port 1433 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
util.c:334:tdserror(0x9a430a8, 0x9a43a08, 20017, 0)
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:316:looking for login token, got 0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(0x9a430a8, 0x9a43a08, 20002, 0)
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:563:tds_free_all_results()
There was a problem connecting to the server


Cheers,
Agnieszka




Archive powered by MHonArc 2.6.24.

Top of Page