Re: Freetds connection problem
"Franck Y" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Sat, Nov 29, 2008 at 3:54 AM, Frediano Ziglio <[email protected]> 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 <[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 > > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > Oh how can i see the port number of the instance ? -- Franck