[freetds] Named Instances

Brian Bruns brian.bruns at gmail.com
Tue Apr 5 06:28:04 EDT 2005


Ack.  Don't use libtds directly, it is a support layer for the higher
level interfaces, and changes from release to release.  Please use
either dblib, ctlib, or ODBC.  dblib is easiest from a setup &coding
perspective.  You can look at the unittest programs for examples or
look on the net, they are plentiful.

Jim et al., let's put a big ass warning in tsql.c not to use libtds, eh?

Brian

On Apr 5, 2005 5:11 AM, Brett <generica at email.com> wrote:
> 
> 
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list