Skip to Content.
Sympa Menu

freetds - Re: [freetds] sql 2005 connection question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Matthijs Langenberg" <mlangenberg AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] sql 2005 connection question
  • Date: Tue, 20 Nov 2007 14:24:16 +0100

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
>




Archive powered by MHonArc 2.6.24.

Top of Page