The most common problem is the password of the user profile used to make the connection expired. Check the QHST log.
<div>-------- Original message --------</div><div>From: Chella R <chella.r@xxxxxxxxx> </div><div>Date:06/15/2014 12:48 AM (GMT-06:00) </div><div>To: midrange-l@xxxxxxxxxxxx </div><div>Subject: Stored Proc Issues </div><div>
I have an application invoking stored proc in the AS400 system. I know that the stored procedure execution is through the ODBC connection from the Appln to AS400. But for past couple of days, when the stored procedure is invoked, no response is being received at the application. All these stored procedures were working well until this issue. We have checked the I-Series drivers on the application, network connectivity at both ends.
What could be the issue? And after an ODBC connection is made, how does the stored procedure invocation gets processed?
Chella Govindarajan R,
Information contained and transmitted by this e-mail is confidential and proprietary to IGATE and its affiliates and is intended for use only by the recipient. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying or use of this e-mail is strictly prohibited and you are requested to delete this e-mail immediately and notify the originator or mailadmin@xxxxxxxxx <mailto:mailadmin@xxxxxxxxx>. IGATE does not enter into any agreement with any party by e-mail. Any views expressed by an individual do not necessarily reflect the view of IGATE. IGATE is not responsible for the consequences of any actions taken on the basis of information provided, through this email. The contents of an attachment to this e-mail may contain software viruses, which could damage your own computer system. While IGATE has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of
software viruses. You should carry out your own virus checks before opening an attachment. To know more about IGATE please visit www.igate.com <http://www.igate.com