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: Wed, 6 Apr 2005 11:16:13 +1000 (EST)


do you mean this:

https://lists.ibiblio.org/sympa/arc/freetds/2005q1/017850.html

so does that mean I have to use the odbc library to get proper named instance support?

/ Brett

On Tue, 5 Apr 2005, Bort, Paul wrote:

Customers always foil the best plans :-)

Freddy Zigliano posted his code handling named instances (for 0.64) to the
list on 2005-01-24. You might want to dig that up.

-----Original Message-----
From: Brett [mailto:generica AT email.com]
Sent: Tuesday, April 05, 2005 7:30 PM
To: FreeTDS Development Group
Subject: RE: [freetds] Named Instances




On Tue, 5 Apr 2005, Bort, Paul wrote:

An instance is two things: An entry in a directory that can
be queried
at port 1434, and a SQL Server listening on a port other than 1433.

You can live without the directory if you can discover the
port number
assigned to the instance you care about. This is available in the
"Server Network Utility" program.

Then just forget the whole 'instance' thing and connect to the SQL
Server on that port.


Sounds good on paper, but for my usage, we'll be telling
users to install the db we need as a named instance, called
'blah', and then trying to connect to that named instance
from the program. We can't assume port numbers, or ask them
to find the port number assigned to that instance, and then
tell the program what it is, so it's important for the
program using tds to be able to connect to an instance by name only.

If this functionality (as described below) will be a while
coming to dblib, then perhaps I'd be better off querying the
sql server to find out the port assigned to the instance? Is
that possible ?

/ Brett


-----Original Message-----
From: Mark Lilback [mailto:mark AT lilback.com]
Sent: Tuesday, April 05, 2005 6:27 PM
To: FreeTDS Development Group
Subject: RE: [freetds] Named Instances

I'm going to want to use this with ctlib without a
freetds.conf file.
Is there any way to set this via properties or to use the instance
name as the host name?


At 10:20 AM +0200 4/5/2005, ZIGLIO, Frediano, VF-IT wrote:
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?


--
______________________________________________________________
____________
"The fetters imposed on liberty at home
have ever
Mark J. Lilback been forged out of the weapons
provided for
<mark AT lilback.com> defence against real, pretended, or
imaginary
http://www.lilback.com/ dangers from abroad." -- James Madison
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page