FreeTDS Development Group

["Andrew H. Wakefield" <a_wake AT earthlink.net>]

One note to add -- I had trouble getting a connection using the server
name (-S option or equivalent), but could get a connection using the
host address and port (-H ip-address -p port) -- it turned out that I
had named an instance (INSTANCE = SQLEXPRESS) in the freetds.conf file,
but my sql server was using a fixed port rather than dynamic ports.
Naming an instance caused the software to try to find a dynamic port.
Taking out the instance name fixed the problem.

Andy Wakefield
a_wake AT earthlink.net 

On Thu, 2010-02-25 at 16:05 +0100, Daniel Fazekas wrote:

> 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
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds