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

Thompson, Bill D (London) bill_d_thompson at ml.com
Wed Aug 25 04:30:16 EDT 2004


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.

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

or, alternatively :

    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
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....

-----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
MS SQL Server 2000?
In order to access the cluster instance, I have to specify the hostname



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
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/ 

More information about the FreeTDS mailing list