Multiple DSNs All Connecting To The Same IP - Sybase ODBC
The problem: You have multiple DSNs defined in your unixODBC's odbc.ini file, and it always connects to the same IP when you try testing with iSQL.The solution:
DO NOT use the following line in your odbc.ini file to define your DSN's port:
CommLinks = tcpip(host=localhost;port=9502)
DO use the following format:
CommLinks = tcpip(HOST=localhost:9502)