Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

IBM Informix Windows ODBC Connection Problem

Posted on 2010-08-23
3
Medium Priority
?
1,949 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 1000 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In this article, we’ll look at how to deploy ProxySQL.
What we learned in Webroot's webinar on multi-vector protection.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

604 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