[freetds] Weirdest thing

Mário Gamito gamito at gmail.com
Mon Feb 11 09:36:31 EST 2008


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

# 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



More information about the FreeTDS mailing list