Re: tsql: Adaptive Server connection failed

Tacho <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
Now can I see clearly how to setting up TDS protocol version and the way how
they affect the database server commands.
Most people skip this things when configuring tds.


#> TDSVER=7.0 isql sqlserver sa e1234 -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit
#> TDSVER=8.0 isql sqlserver sa e1234 -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit
#> TDSVER=4.0 isql sqlserver sa e1234 -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
#> TDSVER=5.0 isql sqlserver sa e1234 -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


thank you very much indeed.

Regards.
Tacho


2010/7/22 <[email protected]>

> Hi,
> You need to clearly differentiate between version of the program
> and whatever this program does.
>
> -----Original Message-----
> >From: Tacho <[email protected]>
> >Sent: Jul 22, 2010 11:34 AM
> >To: FreeTDS Development Group <[email protected]>
> >Subject: Re: [freetds] tsql: Adaptive Server connection failed
> >
> >Additional information:
> >
> ># tsql -C
> >Compile-time settings (established with the "configure" script)
> >                            Version: freetds v0.82
> >             freetds.conf directory: /u02/local/etc
> >     MS db-lib source compatibility: no
> >        Sybase binary compatibility: no
> >                      Thread safety: yes
> >                      iconv library: no
> >                        TDS version: 5.0
> >                              iODBC: no
> >                           unixodbc: yes
> >
> >Here i'm very confused between Version: freetds v0.82 and TDS version:
> 5.0,
> >which of them should be take as the correct version?
>
> Here 0.82 is the version of the freeTDS program (or packet or atom) which
> is supplied
> and needs to be built in order for you to use it.
> 4.0/5.0/7.0/8.0 is the version of TDS protocol (hopefully you know what
> protocol means).
> From freeTDS point of view - 4.0/5.0 is standard protocol versions to talk
> to Sybase Servers
> and 7.0/8.0 are standards to talk to MS SQL.
>
> Which version of MS SQL Server you are trying to talk to?
> Depending on the answer you will select either 7.0 or 8.0 TDS protocol....
>
> HTH.
>
> Thank you.
>
> >
> >Regards.
> >
> >2010/7/22 Tacho <[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
> >>
> >_______________________________________________
> >FreeTDS mailing list
> >[email protected]
> >http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
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.