Skip to Content.
Sympa Menu

freetds - Re: [freetds] connection to SQL server 2008 express

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Fazekas <fdsubs AT t-online.hu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connection to SQL server 2008 express
  • Date: Thu, 25 Feb 2010 16:05:20 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page