Skip to Content.
Sympa Menu

freetds - RE: [freetds] Named Instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bort, Paul" <pbort AT tmwsystems.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Named Instances
  • Date: Wed, 6 Apr 2005 10:29:33 -0400

Yes, that is what I meant.

I don't think it requires ODBC. The line "TDSCONNECTION have
an extra DSTR instance_name field" makes me think that it can be done with
dblib.

Perhaps the author can provide more information?

> -----Original Message-----
> From: Brett [mailto:generica AT email.com]
> Sent: Tuesday, April 05, 2005 9:16 PM
> To: FreeTDS Development Group
> Subject: RE: [freetds] Named Instances
>
>
> 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
> >
> _______________________________________________
> 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