[freetds] Named Instances
Brett
generica at email.com
Wed Apr 6 19:35:30 EDT 2005
Thanks for the info,
It does seem to be connecting to the right instance, but I'm just having a
lot of trouble understanding this library. There doesn't seem to be any
simple instructions on the rudimentary operations I want to do:
connect to a server, instance (got that part)
perform a sql operation - call a stored procedure (got that part)
get the row count for the operation ????
iterate through, grabbing each row returned ????
disconnect (got that part)
I hate to be a bother, but honestly, I've looked at the unittests, and
searched on the web, and inspected the header files, and there just
doesn't seem to be examples that cover such a simple operation.
Any help would be gladly appreciated,
/ Brett
On Wed, 6 Apr 2005, Frediano Ziglio wrote:
> Il giorno mer, 06-04-2005 alle 09:22 +1000, Brett ha scritto:
>> Ah, I see now.
>>
>> I've re-created my test program using dblib, but again I can't see how to
>> specify a named instance using this library. And I can't even see how
>> to specify a freetds.conf file using this library. Finding these
>> plentiful examples on the net isn't as easy as you suggest, and grepping
>> through the unittests isn't the easiest way to learn how to use the
>> library.
>>
>
> Well just to explain. dblib and ctlib usually (with few dirty
> exceptions) REQUIRE freetds.conf. In a server configuration you put an
> "instance" (see UserGuide contained in snapshot for explanation).
> Something like
>
> [myserver]
> host=myhostname
> tds version=8.0
> instance=myinstancename
>
> A sample freetds.conf get installed in the right place when you install
> FreeTDS, edit this file or use ~/.freetds.conf.
>
> If someone want to get rid of FreeTDS perhaps it would be better to
> extend dblib/ctlib server name syntax instead of using strange
> methods... DBI (a Perl library) for example use a syntax like
> "server;option=value" to specify other options. Honestly I prefer
> centralized configuration using freetds.conf...
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
More information about the FreeTDS
mailing list