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: Tue, 5 Apr 2005 20:28:32 -0400

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
>




Archive powered by MHonArc 2.6.24.

Top of Page