FreeTDS Development Group

["Franck Y" <franck110 AT gmail.com>]

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.




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