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: "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




Archive powered by MHonArc 2.6.24.

Top of Page