Re: Freetds connection problem
"Franck Y" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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. 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