FreeTDS Development Group

["Wilson, Allan" <Allan.Wilson AT railinc.com>]

A solution was found using SOCAT (from socat.org)

SOCAT acts as a proxy -

SOCAT was setup to bind the required interface and listen on a specific
port and to forward the requests to the SQL Server instance.  TSQL
connects to the address and port of SOCAT, SOCAT then forwards the
request to the SQL Server and relays the packets back to TSQL.  Pretty
Cool.

Allan

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Saturday, October 23, 2004 12:56 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Need some help

"Wilson, Allan" <Allan.Wilson AT railinc.com> wrote:
> Is there a way to have FeeTDS
> send a connection from a specific IP address on our Unix box?

Yes, but it's not a FreeTDS question.  It's a tcp/ip routing question.  

I'm not a network admin, and I can't offer you specific advice.  If I
were
tackling this, I'd probably create an entry in freetds.conf pointing to
localhost.  (You might need to add an alias ip address for the loopback
device.) Then I'd add a static route (or possibly an internal firewall)
using the "specific IP address" as the next hop.  Once the packet
arrives
there, it will be forwarded according to the regular rules.  

Something along those lines.  I'd be interested to hear what you
ultimately do.  

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds