[freetds] Named Instances
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Tue Apr 5 04:20:15 EDT 2005
> >> 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.
I know, the boss is always the boss :)
> >> 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
> >> 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
> > 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?
More information about the FreeTDS