[freetds] Named Instances

Bort, Paul pbort at tmwsystems.com
Wed Apr 6 10:29:33 EDT 2005


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:
> 
> http://lists.ibiblio.org/pipermail/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
> 


More information about the FreeTDS mailing list