[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