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
Solved

IBM Informix Windows ODBC Connection Problem

Posted on 2010-08-23
3
1,922 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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Backup Strategy 15 44
Is it safe to dump postgresql database that is in production? 3 38
Help With Simple Database Design 7 50
Need network only 1 user? 10 66
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
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…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

840 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