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: Javier Oviedo <joviedo AT plcendesa.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 17:24:14 +0100

ZIGLIO, Frediano, VF-IT wrote:

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

>Usually we suggest following steps
>- ping if hostname used. Does machine resolve ip from name?
>
>
ping sqlserver
PING sqlserver (172.25.X.X) 56(84) bytes of data.
64 bytes from sqlserver (172.25.X.X): icmp_seq=0 ttl=123 time=9.85 ms
64 bytes from sqlserver (172.25.X.X): icmp_seq=1 ttl=123 time=10.1 ms
64 bytes from sqlserver (172.25.X.X): icmp_seq=2 ttl=123 time=9.91 ms

>- telnet to sql port. This avoid problems with firewall and similar
>
>
telnet 172.25.X.X 1433
Trying 172.25.X.X...
telnet: Unable to connect to remote host: Connection refused

I can't do telnet to an sql port from linux but I can connecto to an SQL
Server with my laptop . My laptop this one in the same subnet that the
linux machine.

>- tsql with -H -p -U -P to check lower FreeTDS layer (libTDS)
>
>
tsql -H sqlserver -p 1433 -U **
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
src/tds/login.c: tds_connect: 172.25.X.X:1433: Connection refused
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 with -S -U -P to check for freetds.conf configuration
>
>
tsql -S 172.25.X.X -U ** -P ***
locale is "en_US.UTF-8"
locale charset is "UTF-8"
src/tds/login.c: tds_connect: 172.25.X.X:1433: Connection refused
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

>- try with same parameter on upper layer (PHP script and similar)
>
>freddy77
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
>
>
Regards!





Archive powered by MHonArc 2.6.24.

Top of Page