Skip to Content.
Sympa Menu

freetds - [freetds] tsql: Adaptive Server connection failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tacho <tachoymu AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] tsql: Adaptive Server connection failed
  • Date: Thu, 22 Jul 2010 08:25:18 -0700

*FACTS:*

Oracle Server Machine: AIX 5L 5.3 (64bit)
Oracle Release: 11g R1
CC Compiler: gcc 3.3.2
freeTDS version:0.82
unixODBC version:2.3.0
MS SQL Server Machine: Windows Server 2003
SQL Server release: SQL Server 2005

when we run tsql command to make a connection from Oracle to MS SQL Server,
the following error is thrown:

regatta[/u02/local/etc]> tsql -H sqlserver -p 1433 -U sa -P x1234
locale is "en_US en_US en_US en_US en_US en_US"
locale charset is "ISO8859-1"
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

the following messages can be seen in tsql log file after running the above
command:

08:48:53.474852 1724446 (log.c:190):Starting log file for FreeTDS 0.82
on 2010-07-22 08:48:53 with debug flags 0xffff.
08:48:53.475135 1724446 (iconv.c:78):Using trivial iconv
08:48:53.475170 1724446 (iconv.c:197):names for ISO-8859-1: ISO-8859-1
08:48:53.475180 1724446 (iconv.c:197):names for UTF-8: UTF-8
08:48:53.475187 1724446 (iconv.c:197):names for UCS-2LE: UCS-2LE
08:48:53.475195 1724446 (iconv.c:197):names for UCS-2BE: (null)
08:48:53.475203 1724446 (iconv.c:363):iconv to convert client-side data to
the "ISO8859-1" character set
08:48:53.475219 1724446 (iconv.c:516):tds_iconv_info_init: converting
"ISO-8859-1"->"UCS-2LE"
08:48:53.475432 1724446 (net.c:210):Connecting to 192.168.210.182 port 1433
(TDS version 5.0)
08:48:53.490244 1724446 (net.c:264):tds_open_socket: connect(2) returned "A
connect operation on a socket is not complete."
08:48:53.490266 1724446 (net.c:303):tds_open_socket() succeeded
08:48:53.490276 1724446 (util.c:162):Changed query state from DEAD to IDLE


and also, when isql command is run the following error is issued:

regatta[/u02/local/etc]> isql sqlserver sa x1234 -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[01000][unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
[ISQL]ERROR: Could not SQLConnect

I don't know why, if everthing appears to be correct:

odbc.ini

[SQLSERVER]
Driver=TDS
Trace=0
TraceFile=/tmp/sqlserver.log
Servername=192.168.210.182
Database=PEDB
Port=1433

odbcinst.ini

[TDS]
Description=FreeTDS driver
driver=/u02/local/lib/libtdsodbc.so.0
Setup=/u02/local/lib/libtdsodbc.so.0
Trace=Yes
TraceFile=/tmp/freetds.log
FileUsage=1
UsageCount=1

freetds.conf

[SQLSERVER]
host = 192.168.210.182
port = 1433
tds version = 0.82

and if we do a connection test using telnet and ping everthing work as
expected

# ping 192.168.210.182
PING 192.168.10.82: (192.168.10.82): 56 data bytes
64 bytes from 192.168.210.182: icmp_seq=0 ttl=128 time=0 ms
64 bytes from 192.168.210.182: icmp_seq=1 ttl=128 time=0 ms
64 bytes from 192.168.210.182: icmp_seq=2 ttl=128 time=0 ms
64 bytes from 192.168.210.182: icmp_seq=3 ttl=128 time=0 ms
..
..
----192.168.10.82 PING Statistics----
14 packets transmitted, 14 packets received, 0% packet loss
round-trip min/avg/max = 0/0/1 ms

# telnet 192.168.210.182 1433
Trying...
Connected to 192.168.210.182.
Escape character is '^]'.
quit
Connection closed.



Hope you can shed some light on this problem.

thanks and regards.
Tacho




Archive powered by MHonArc 2.6.24.

Top of Page