FreeTDS Development Group

[Daniel Fazekas <fdsubs AT t-online.hu>]

On Feb 25, 2010, at 14:24, Mahendra T wrote:

> I am able to connect to the database by mentioning the port number in the  
> query,
> like TDSPORT=1433 TDSDUMP=/home/user/freetds.log tsql -S IP_Address -U  
> user_name
> but if it is trying to connect at port 4000 if I don't mention the  
> TDSPORT, though the port is set to 1433 in freetds.conf file.

The -S option in tsql takes a freetds.conf section name rather than the IP 
address.

So if you have something like this in your freetds.conf:

[myserver]
host = IP_Address
port = 1433
tds version = 8.0

Then use -S myserver