Skip to Content.
Sympa Menu

freetds - RE: [freetds] 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: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] How to configure Freetds to access cluster instance MS SQL Server
  • Date: Wed, 25 Aug 2004 09:30:16 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page