IBM Informix Windows ODBC Connection Problem
Posted on 2010-08-23
I am setting up several Windows machines using ODBC clients to connect to IBM Informix DB. When testing the ODBC connections I got quick responses on some machines and slow responses (delays ranging from 2s ~ 10+s) for the others. After capturing the TCP packets I found that for a quick response the TCP packet returned from DB right after the last request packet was sent is a PSH ACK packet already containing the actual response TCP payload, while for a slow response the first packet returned is only a ACK packet for the request, and another PSH ACK packet (containing the response payload) was then received only after the mentioned delay. Is the problem related to DB configurations or firewall configurations?
Any kind of help is greatly appreciated!
Informix version: 11.x
ODBC Client version: 3.50.FC4
OS: Windows Server 2008 64-bit