[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