[freetds] Named Instances

Brett generica at email.com
Tue Apr 5 19:30:05 EDT 2005




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
>


More information about the FreeTDS mailing list