Re: Freetds connection problem

"James K. Lowden" <[email protected]> Fri, 21 Nov 2008 17:46:21 -0500

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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