[freetds] Named Instances

Brett generica at email.com
Tue Apr 5 05:11:53 EDT 2005




On Tue, 5 Apr 2005, ZIGLIO, Frediano, VF-IT wrote:

>>>> I'm just wondering how to get this to work, since it doesn't
>>>> seem to be
>>>> fully implemented.  I was expecting there to be a
>>>> tds_set_instance() call,
>>>> but that doesn't exist yet.  And setting the instance name in
>>>> freetds.conf
>>>> doesn't seem to work, from tsql, probably for that reason.
>>>> Does this mean
>>>> (for now) you have to manually set it in the *TDSCONNECTION ?
>>>>
>>>> Would I be better off writing the code to implement
>>>> tds_set_instance() and
>>>> submitting it, or am I on the wrong track.
>>>>
>>>
>>> Current CVS support named instance (TODOs involve only
>> documentation I
>>> tested even on cluster environment). Use "instance" option on
>>> freetds.conf and Server=host\instance syntax for ODBC
>> (freetds.conf-less
>>> and dsn-less).
>>
>> Since posting, I found that the freetds.conf was working, but this
>> server=host\instance sounds much better.
>>
>> Can I then guess that using
>>
>> tds_set_server(login, "servername\instance");
>>
>> will work ?
>>
>> if so, perfect
>>
>
> 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?
>

Ok, well then I am confused, and don't even know what library i'm using. 
I'm simply duplicating code from the tsql.c file, and linking with -ltds. 
Is this what you mean or not?  I just need a way to specify a named 
instance, without using the freetds.conf file.

 	/ Brett


More information about the FreeTDS mailing list