FreeTDS Development Group

["Dan Wierenga" <dwierenga AT valueclick.com>]

You should be able to set the TDSHOST environment variable to override
the actual host in the freetds.conf entry.  So, you'd set that 9 times,
once before each connection is made.  See
http://freetds.org/userguide/envvar.htm

It's ugly but it should work.  Maybe Frediano or JKL has a more elegant
solution though..

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> bounces AT lists.ibiblio.org] On Behalf Of Middleton, Eric
> Sent: Wednesday, January 16, 2008 2:13 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Sybase ASA 9, unixODBC multiple connection
> problem
> 
> Ok you lost me.  My problem is I need to know how to set up my linux
> box
> to have 9 different odbc connections to 9 different Sybase 9 servers.
> 
> Thanks,
> Eric Middleton
> Oncology Supply Automation
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Dann Corbit
> Sent: Wednesday, January 16, 2008 4:07 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Sybase ASA 9, unixODBC multiple connection
> problem
> 
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> > bounces AT lists.ibiblio.org] On Behalf Of Middleton, Eric
> > Sent: Wednesday, January 16, 2008 1:27 PM
> > To: freetds AT lists.ibiblio.org
> > Subject: [freetds] Sybase ASA 9, unixODBC multiple connection
problem
> >
> > I am using centos5 and with unixODBC and FreeTDS installed.
> >
> > I have to problem connecting to a single Sybase server however I
need
> to
> > be able to connect to 9 of them.
> >
> > They are Sybase version 9 and it seems in the odbc.ini that if the
> > server name in the config is not the name of the actual database
file
> > then the connection does not work.  Well this is a problem because
> all
> 9
> > servers have a database that is the same.  So the only difference is
> the
> > IP.  However since the ip is in the freeTDS.conf file then I can
only
> > connect to the first server in the .conf file.  Does anyone know a
> work
> > around for this?  Here is my config files.
> > Odbc.ini
> > [mydsn2]
> > Description = blah
> > Driver = TDS
> > Servername = central
> > UID = user
> > PWD = pass
> > Port = 2638
> >
> > Freetds.conf
> > [central]
> >         host = serverip
> >         port = 2638
> >         tds version = 4.2
> >
> > this works because central is the name of the database. But like I
> said
> > I need to connect to 9 of these not just one.  Any help would be
> greatly
> > appreciated.
> 
> I am not sure if I understand your problem, but have you tried
creating
> nine different Sybase data sources and nine different connections?
> (E.g.
> name them after the servers)
> 
> I have no difficulty creating multiple connections to the same or to
> different databases (caveat: we did find that multiple simultaneous
> queries to the same database require different connections -- you
can't
> multiplex queries on the same connection).
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> CONFIDENTIALITY NOTICE.  This electronic mail transmission may contain
> privileged and/or confidential
> information and is intended only for the review of the party to whom
it
> is addressed.   If you have
> received this transmission in error, please immediately return it to
> the sender, delete it  and destroy
> it without reading it.  Unintended transmission shall not constitute
> the waiver of the attorney-client
> or any other privilege.
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds