[CR #540023] ETL may not connect to a specific Sybase IQ server using ODBC if there are multiple Sybase IQ servers with the same server name, database name, and port number.
Workaround: Use server name caching to connect to the target Sybase IQ server. Add the DoBroadcast=DIRECT communication parameter to the CommLinks connection parameter in the .odbc.ini file in your ETL Server:
CommLinks=tcpip(DoBroadCast=DIRECT;host=iq server;port=2638)
See “Server name caching for faster connections,” in Chapter 3, “Sybase IQ Connections” in the Sybase IQ 12.7 System Administration Guide.
