[freetds] connection to SQL server 2008 express
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