FreeTDS Development Group

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

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.



Thanks,
Eric Middleton


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.