tsql: Adaptive Server connection failed

Tacho <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
*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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.