freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Freetds connection problem

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Freetds connection problem
Date: Fri, 21 Nov 2008 17:46:21 -0500

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] Freetds connection problem, Franck Y, 11/21/2008
- Re: [freetds] Freetds connection problem, James K. Lowden, 11/21/2008
  - Re: [freetds] Freetds connection problem, Franck Y, 11/26/2008
    - Re: [freetds] Freetds connection problem, Frediano Ziglio, 11/29/2008
      - Re: [freetds] Freetds connection problem, Franck Y, 11/29/2008
        
        Re: [freetds] Freetds connection problem, James K. Lowden, 11/29/2008