[freetds] Connecting to an SQL 2005 server in a windows 2000 machine[Scanned]

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Jan 30 10:36:19 EST 2006


> Hi michael
> 
> I check my SQL Server configuration and it listen on port 1433 and ip 
> 172.25.X.X . I can connecto to SQL from my laptop with Toad 
> and SQL 2005
> Manager.
> This is the output from tsql -C:
> 
>  tsql -C
> Compile-time settings (established with the "configure" script):
>                            Version: freetds v0.63
>     MS db-lib source compatibility: no
>        Sybase binary compatibility: unknown
>                      Thread safety: yes
>                      iconv library: yes
>                        TDS version: 8.0
>                              iODBC: yes
>                           unixodbc: no
> 
> Regards

Usually we suggest following steps
- ping if hostname used. Does machine resolve ip from name?
- telnet to sql port. This avoid problems with firewall and similar
- tsql with -H -p -U -P to check lower FreeTDS layer (libTDS)
- tsql with -S -U -P to check for freetds.conf configuration
- try with same parameter on upper layer (PHP script and similar)

freddy77


More information about the FreeTDS mailing list