Re: Freetds connection problem

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 <[email protected]> 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
> > [email protected]
> > 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