[freetds] Named Instances
Brett
generica at email.com
Tue Apr 5 03:11:14 EDT 2005
On Tue, 5 Apr 2005, ZIGLIO, Frediano, VF-IT wrote:
>>
>> Hi,
>>
>> As part of porting our software from linux to win32, we have
>> to switch
>> from Postgresql to MS SQL. I've been investigating using
>
> Why not Postgresql on windows (the "we have to" seems a bit strong to
> me) ?
Like every 'we have to', this is because someone higher up the food chain
than me has made this decision and will not be swayed. Yes, if I had my
way, I'd simply use psql8 on windows.
>
>> freedts to talk
>> to sql server, but hit upon problems because named instances weren't
>> implemented. Then noticed that they were available in cvs,
>> and here I am.
>>
>
> Well, instances are just different server that run on different port.
> Asking to administrator for instance port will fix all your problems.
>
>> 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
thanks,
/ Brett
More information about the FreeTDS
mailing list