Skip to Content.
Sympa Menu

freetds - Re: [freetds] Weirdest thing

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mário Gamito <gamito AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Weirdest thing
  • Date: Mon, 11 Feb 2008 15:04:32 +0000

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 AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page