Multiple DSNs All Connecting To The Same IP - Sybase ODBCThe 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.
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)