Skip to Content.
Sympa Menu

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

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] Connecting to an SQL 2005 server in a windows 2000 machine[Scanned]
  • Date: Mon, 30 Jan 2006 16:36:19 +0100


> 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




Archive powered by MHonArc 2.6.24.

Top of Page