[freetds] sql 2005 connection question

Matthijs Langenberg mlangenberg at gmail.com
Tue Nov 20 08:24:16 EST 2007


This is the default way SQL2005 servers are identified aren't they? I got
asked the same question a few days ago:"Now we are able to connect it to a
MSSQL server, can u use the \SQL2005 notation to connect to our MSSQL2005
server?"

Can you clean things up Ryan? I'm also not a pro on this area.

- Matthijs

On Nov 20, 2007 3:05 AM, James K. Lowden <jklowden at freetds.org> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list