[freetds] connection to SQL server 2008 express

Daniel Fazekas fdsubs at t-online.hu
Thu Feb 25 10:05:20 EST 2010

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:

host = IP_Address
port = 1433
tds version = 8.0

Then use -S myserver

More information about the FreeTDS mailing list