FreeTDS Development Group

["Middleton, Eric" <eric.middleton AT oncologysupply.com>]

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.