Skip to Content.
Sympa Menu

freetds - Re: [freetds] Weirdest thing

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Weirdest thing
  • Date: Mon, 11 Feb 2008 15:50:02 +0100

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page