Skip to Content.
Sympa Menu

freetds - [freetds] Sybase ASA 9, unixODBC multiple connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Middleton, Eric" <eric.middleton AT oncologysupply.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Sybase ASA 9, unixODBC multiple connection problem
  • Date: Wed, 16 Jan 2008 15:27:27 -0600

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.




Archive powered by MHonArc 2.6.24.

Top of Page