[freetds] sql 2005 connection question

James K. Lowden jklowden at freetds.org
Mon Nov 19 21:05:29 EST 2007


Ryan Knopp wrote:
> Can freetds handle these type of mssql server strings?
> 
> Server = <ip>\SQL2005
...
> Server = 127.0.0.1\SQL2005

You could be lucky, but I don't know if that can be made to work.  You can
use TDSDUMP and TDSDUMPCONFIG to see if your connection is going to the
right place.  

I have to say I'm mystified why anyone would do that.  DNS was invented to
make remembering IP addressed unnecessary.  freetds.conf was devised to
assign a name to the collection of properties the library needs to know
about the server.  You're abandoning all that, but then hoping automatic
port negotiation will work?  Whatever for, man?  

Regards, 

--jkl



More information about the FreeTDS mailing list