Skip to Content.
Sympa Menu

freetds - RE: [freetds] Named Instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brett <generica AT email.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Named Instances
  • Date: Tue, 5 Apr 2005 19:11:53 +1000 (EST)




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




Archive powered by MHonArc 2.6.24.

Top of Page