[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Weirdest thing
From:       Mário_Gamito <gamito () gmail ! com>
Date:       2008-02-11 15:04:32
Message-ID: 47B06400.4070902 () gmail ! com
[Download RAW message or body]

Hi,

Thank you for your answer.
Unfortunately, is no good :(

Here's the dump:

"util.c:288:Starting log file for FreeTDS 0.64
         on 2008-02-11 15:00:10 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" 
character set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:168:Connecting to 192.168.1.21 port 1433.
net.c:256:connect error: Connection refused
util.c:119:Changing query state from IDLE to DEAD
token.c:2252:tds_client_msg: #20009: "Server is unavailable or does not 
exist.".  Connection state is now 4.
mem.c:519:tds_free_all_results()"

Any ideas ?

Warm Regards,
Mário Gamito

ZIGLIO, Frediano, VF-IT wrote:
> > Hi,
> > 
> > I'm trying to use FreeTDS to connect a Linux box 
> > (192.168.1.4) to a MS 
> > SQL SERVER 2005 (192.168.1.21).
> > 
> > I believe I have everything right. But I get a connection 
> > refused  when 
> > I try to telnet from Linux to Windows. Oddly enough, other 
> > machines on 
> > the same network can get through with no problems.
> > 
> > 
> > I have this in freetds.conf:
> > [tds]
> > host = 192.168.1.21
> > port = 1433
> > tds version = 8.0
> > 
> > # tsql -S 'PTSQL-WWLIB\sql2005' -P secret -U sa
> > locale is "en_US.ISO-8859-1"
> > locale charset is "ISO-8859-1"
> > There was a problem connecting to the server
> > 
> 
> Probably server is not using port 1433. -S specify a freetds.conf configuration so \
> 'PTSQL-WWLIB\sql2005' is not correct. 
> Try with
> 
> [tds]
> host = 192.168.1.21
> instance = sql2005
> tds version = 8.0
> 
> # tsql -S tds -U sa
> 
> Probably you want to connect to instance sql2005 of 192.168.1.21. Newer version \
> support server\instance syntax like MS ODBC. 
> > # tsql -H tds -U sa
> > locale is "en_US.ISO-8859-1"
> > locale charset is "ISO-8859-1"
> > Password:
> > Msg 20009, Level 9, State 0, Server OpenClient, Line 0
> > Server is unavailable or does not exist.
> > There was a problem connecting to the server
> > 
> > tsql -C shows:
> > "# tsql -C
> > Compile-time settings (established with the "configure" script):
> > Version: freetds v0.64
> > MS db-lib source compatibility: no
> > Sybase binary compatibility: unknown
> > Thread safety: yes
> > iconv library: yes
> > TDS version: 5.0
> > iODBC: no
> > unixodbc: yes"
> > 
> > Any help would be appreciated.
> > 
> > Warm Regards,
> > Mário Gamito
> 
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]