[freetds] RE: How to configure Freetds to access cluster instance MS SQL Server

jun_chen at bankone.com jun_chen at bankone.com
Thu Aug 26 09:44:03 EDT 2004


Thanks a lot, Bill. That works.

Jun 


Jun Chen

Date: Wed, 25 Aug 2004 09:30:16 +0100
From: "Thompson, Bill D (London)" <bill_d_thompson at ml.com>
Subject: RE: [freetds] How to configure Freetds to access cluster
                 instance MS             SQL Server
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Message-ID:
 <EA147559111B6D489258F903ADB908780631924F at mllna201mb-m.uk.ml.com>
Content-Type: text/plain;                charset="us-ascii"

Jun,

Its not a problem, I do it all the time.

First you need to know the IP address and Port number that that server
instance is operating on.
Get this from your SQL server admin...

Then, set up the freetds.conf file entry for the server, e.g.

[MYSERVER]
    host = 123.456.789.123
    port = 9999
    initial block size = 4096
    tds version = 8.0

or, alternatively :

[MYSERVER]
    host = ino0w062n2.svr.bankone.net
    port = ????
    initial block size = 4096
    tds version = 8.0

Your different instances will listen on different port numbers.

Its best to give the server a simple server name as far as freetds is
concerned.
specifically its best not to have a "\" in the name, as if you have to
specify this on a UNIX command line,
the shell will get confused....


Bill
-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of
jun_chen at bankone.com
Sent: 24 August 2004 20:38
To: freetds at lists.ibiblio.org
Subject: [freetds] How to configure Freetds to access cluster instance
MS SQL Server


Hi All,

Does anyone know how to configure freetds to access a cluster instance
of 
MS SQL Server 2000?
In order to access the cluster instance, I have to specify the hostname
as 
ino0w062n2.svr.bankone.net\midrangeim.

Thanks.

Jun

This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you.

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds 
--------------------------------------------------------
 
If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain 
or redistribute it. Click here for important additional terms relating to 
this e-mail.     http://www.ml.com/email_terms/ 
--------------------------------------------------------
 


------------------------------

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


End of FreeTDS Digest, Vol 19, Issue 22
***************************************





More information about the FreeTDS mailing list