Solved

IBM Informix Windows ODBC Connection Problem

Posted on 2010-08-23
3
1,914 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:PYA172
  • 2
3 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 250 total points
ID: 33508536
This problem is ususally related to problems with DNS setup
Informix server tries to find client name from IP and waits for timeout.
0
 

Author Comment

by:PYA172
ID: 33517473
Thanks gheist for your comment and I will ask my colleagues in network team to check the DNS. I will accept this as solution once the problem has been confirmed solved by them.
0
 
LVL 62

Expert Comment

by:gheist
ID: 33519238
Or disable DNS lookup on informix server (nameserver 127.0.0.1)
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question