Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: jun_chen AT bankone.com
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] RE: How to configure Freetds to access cluster instance MS SQL Server
  • Date: Thu, 26 Aug 2004 09:44:03 -0400

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





  • [freetds] RE: How to configure Freetds to access cluster instance MS SQL Server, jun_chen, 08/26/2004

Archive powered by MHonArc 2.6.24.

Top of Page