[freetds] Named Instances

Brett generica at email.com
Tue Apr 5 21:16:13 EDT 2005


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
>


More information about the FreeTDS mailing list