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: "Franck Y" <franck110 AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Freetds connection problem
  • Date: Sat, 29 Nov 2008 09:49:57 -0500

On Sat, Nov 29, 2008 at 3:54 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 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
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

Oh how can i see the port number of the instance ?

--
Franck




Archive powered by MHonArc 2.6.24.

Top of Page