[freetds] connection to SQL server 2008 express

Andrew H. Wakefield a_wake at earthlink.net
Thu Feb 25 11:02:54 EST 2010


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



More information about the FreeTDS mailing list