Zend PHP page calling a procedure and returning Unable to access statement result, SQL error: 58004-SQL system error.

Hello.

We are at our whit's end trying to resolve this issue. Hoping you can all help or point us in the right direction.

We have a procedure to get information from our iSeries database. I can run this procedure via other methods (Squirrel, iSeries Navigator, etc.) as my profile and it pulls the proper data. Anytime the Zend/PHP server runs the procedure we are getting the error - Unable to access statement result, SQL error: 58004-SQL system error. For giggles, we gave the QTMHHTTP profile a password and signed on with Squirrel it worked properly. I checked permissions and they all seem to be in order. We have another system that doesn't seem to have any trouble with this either.

We are on V7R1M0 if that makes a difference. Zend version of Zend Server for IBM i 6.1.0 ( PHP 5.4 ).

Thanks in advance for any help you can give.

Brian Neifert
Enterprise Solutions Architect
Oldcastle BuildingEnvelope(r)
One Seagate
Suite 1750
Toledo, OH 43604
Direct Phone (419) 887-1212, x50105
Fax (419) 887-4593
obe.com


The information transmitted herein is confidential information intended only for the viewing and use of the individual recipient named above. If you are not the intended recipient, you are hereby notified that any review, use, communication, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone or reply e-mail, delete this message and destroy any printed copies. Thank you.