FreeTDS Development Group

[Brett <generica AT email.com>]

do you mean this:

https://lists.ibiblio.org/sympa/arc/freetds/2005q1/017850.html

so does that mean I have to use the odbc library to get proper named 
instance support?

        / Brett

On Tue, 5 Apr 2005, Bort, Paul wrote:

> Customers always foil the best plans :-)
>
> Freddy Zigliano posted his code handling named instances (for 0.64) to the
> list on 2005-01-24. You might want to dig that up.
>
> > -----Original Message-----
> > From: Brett [mailto:generica AT email.com]
> > Sent: Tuesday, April 05, 2005 7:30 PM
> > To: FreeTDS Development Group
> > Subject: RE: [freetds] Named Instances
> >
> >
> >
> >
> > On Tue, 5 Apr 2005, Bort, Paul wrote:
> >
> > > An instance is two things: An entry in a directory that can
> > be queried
> > > at port 1434, and a SQL Server listening on a port other than 1433.
> > >
> > > You can live without the directory if you can discover the
> > port number
> > > assigned to the instance you care about. This is available in the
> > > "Server Network Utility" program.
> > >
> > > Then just forget the whole 'instance' thing and connect to the SQL
> > > Server on that port.
> >
> > Sounds good on paper, but for my usage, we'll be telling
> > users to install the db we need as a named instance, called
> > 'blah', and then trying to connect to that named instance
> > from the program.  We can't assume port numbers, or ask them
> > to find the port number assigned to that instance, and then
> > tell the program what it is, so it's important for the
> > program using tds to be able to connect to an instance by name only.
> >
> > If this functionality (as described below) will be a while
> > coming to dblib, then perhaps I'd be better off querying the
> > sql server to find out the port assigned to the instance?  Is
> > that possible ?
> >
> >         / Brett
> >
> > > > -----Original Message-----
> > > > From: Mark Lilback [mailto:mark AT lilback.com]
> > > > Sent: Tuesday, April 05, 2005 6:27 PM
> > > > To: FreeTDS Development Group
> > > > Subject: RE: [freetds] Named Instances
> > > >
> > > > I'm going to want to use this with ctlib without a
> > freetds.conf file.
> > > > Is there any way to set this via properties or to use the instance
> > > > name as the host name?
> > > >
> > > >
> > > > At 10:20 AM +0200 4/5/2005, ZIGLIO, Frediano, VF-IT wrote:
> > > > > No, do not confuse ODBC with other stuff. This is implemented in
> > > > > ODBC for compatibility with MS specifications. libTDS do
> > not handle
> > > > > this syntax. Why would you like this syntax? Which
> > library are you using?
> > > > --
> > > > ______________________________________________________________
> > > > ____________
> > > >                           "The fetters imposed on liberty at home
> > > > have ever
> > > > Mark J. Lilback           been forged out of the weapons
> > provided for
> > > > <mark AT lilback.com>        defence against real, pretended, or
> > > > imaginary
> > > > http://www.lilback.com/   dangers from abroad."  -- James Madison
> > > > _______________________________________________
> > > > FreeTDS mailing list
> > > > FreeTDS AT lists.ibiblio.org
> > > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds