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: Wed, 26 Nov 2008 20:49:02 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page