Paul's Programming Notes     Archive     Feed     Github

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)