FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Atkinson.Keith
> Sent: Thursday, February 02, 2006 2:35 PM
> 
> I would like to thank all for responding to my question, no matter
> how vague. Secondly, I would like to apologize for being so vague,
> this is my first time to present a question.

No problem, Keith.  Just keep in mind how much more successful the
Internet is at communicating information as compared with, say, mind
reading.  ;-)

> To be more precise, I'm trying to query MS_SQL 2000 that has several
> incidents (complete databases setups for testing on the same phyiscal
> box, and with the same IP, and port) so, normally in the freetds.conf
> or interface you would setup the structure as shown below:
> 
>      demoacctv
>      query tcp 4.2 172.19.5.18 1433
> 
> Mulitple incidents:
>                demoacctv\acct2
>                query tcp 4.2 172.19.5.18 1433
> 
>                demoacctv\acct3
>                query tcp 4.2 172.19.5.18 1433

Ah.  Not "Mulitple incidents" but "multiple instances".  You have two
choices, both in freetds.conf.  

Different instances of the server are found at the same address
(obviously) but listen to different ports.  

Using 0.63, treat them as different servers by distinguishing their
ports:  

    1.  Find out the port for each instance.  
    2.  Create a [servername] entry for each one in freetds.conf.
Something like:

        [acct2]
                host = 172.19.5.18
                port = 1435     
        [acct3]
                host = 172.19.5.18
                port = 1436

Using a current snapshot, you can specify the instance name instead (cf.
http://www.schemamania.org/projects/freetds/build/doc/doc/freetds-0.64.d
ev.20051121/userguide/freetdsconf.htm):

        [acct2]
                host = 172.19.5.18
                instance = acct2
        [acct3]
                host = 172.19.5.18
                instance = acct3

If the DNS name of 172.19.5.18 is 'demoacctv', I recommend using the
name instead:

        [acct2]
                host = demoacctv
                instance = acct2
        [acct3]
                host = demoacctv
                instance = acct3

Whichever approach you use, in your application you refer to the
instance as a server, according to the name you gave it (e.g. acct2 and
acct3, above).  

Hope that clears things up for you.  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.