[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