Re: connection to SQL server 2008 express
"Andrew H. Wakefield" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <1267113774.4877.2.camel@uwake-laptop> |
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 [email protected] 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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds