FreeTDS Development Group

["Dann Corbit" <DCorbit AT connx.com>]

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