Re: connection to SQL server 2008 express

Daniel Fazekas <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.