Skip to Content.
Sympa Menu

freetds - Re: [freetds] Freetds connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Freetds connection problem
  • Date: Sat, 29 Nov 2008 09:54:09 +0100

Il giorno mer, 26/11/2008 alle 20.49 -0500, Franck Y ha scritto:
> On Fri, Nov 21, 2008 at 5:46 PM, James K. Lowden <jklowden AT freetds.org>
> wrote:
> > Franck Y wrote:
> >>
> >> First i am running SQL server 2005.
> >>
> >> 1) i did a telnet 1433 on my server and it work correclty so my
> >> problem is not a firewall related problem.
> >>
> >> 2)In SQL server 2005 the server name is "MYSERVER\SL"
> >>
> >> I created a file under /etc/freetds.conf
> >>
> >> like this
> >>
> >> -----
> >> [MS1]
> >> host = 192.168.10.50
> >> port = 1433
> >> tds version = 7.0
> >>
> >
> > I think you want something more like:
> >
> > [MS1]
> > host = MYSERVER
> > instance = SL
> > tds version = 7.0
> >
> > Cf. "man freetds.conf" in the 0.82 distribution or later.
> >
> > HTH.
> >
> > --jkl
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
> Hello,
>
> It still does not work, here is my new freetds.conf
> *****************************************************
> [MSSQL1]
> host = MYSERVER
> instance=SL
> tds version = 7.0
> dump file= /home/******/tds.log
> dump file append= yes
> port=1433
> ************************************
> i have added the port number because i had the error
> 'login.c:418:invalid port number' but i was not luckier.
>
>

port 1433 ?? port 1433 is the default instance, not SL one!
You can specify instance OR port number. You could try removing instance
if you know the port.

>
>
> here is the log file
> **************************************************************************
> log.c:190:Starting log file for FreeTDS 0.82
> on 2008-11-26 20:44:13 with debug flags 0x4fff.
> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> iconv.c:197:names for UTF-8: UTF-8
> iconv.c:197:names for UCS-2LE: UCS-2LE
> iconv.c:197:names for UCS-2BE: UCS-2BE
> iconv.c:363:iconv to convert client-side data to the "ANSI_X3.4-1968"
> character set
> iconv.c:516:tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> net.c:836:tds7_get_instance_port(192.168.10.50, SL)
> net.c:905:tds7_get_instance_port: timed out on try 0 of 16
> net.c:905:tds7_get_instance_port: timed out on try 1 of 16
> net.c:905:tds7_get_instance_port: timed out on try 2 of 16
> net.c:905:tds7_get_instance_port: timed out on try 3 of 16
> net.c:905:tds7_get_instance_port: timed out on try 4 of 16
> net.c:905:tds7_get_instance_port: timed out on try 5 of 16
> net.c:905:tds7_get_instance_port: timed out on try 6 of 16
> net.c:905:tds7_get_instance_port: timed out on try 7 of 16
> net.c:905:tds7_get_instance_port: timed out on try 8 of 16
> net.c:905:tds7_get_instance_port: timed out on try 9 of 16
> net.c:905:tds7_get_instance_port: timed out on try 10 of 16
> net.c:905:tds7_get_instance_port: timed out on try 11 of 16
> net.c:905:tds7_get_instance_port: timed out on try 12 of 16
> net.c:905:tds7_get_instance_port: timed out on try 13 of 16
> net.c:905:tds7_get_instance_port: timed out on try 14 of 16
> net.c:905:tds7_get_instance_port: timed out on try 15 of 16
> net.c:974:instance port is 0
> login.c:418:invalid port number
> **************************************************************************
> Thanks for the help

Mmm... possibly there is no SL instance...

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page