[freetds] Named Instances

Bort, Paul pbort at tmwsystems.com
Tue Apr 5 20:28:32 EDT 2005


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
> 


More information about the FreeTDS mailing list