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

I get a syntax error trying to call an informix stored procedure.

Posted on 2010-11-30
1
606 Views
Last Modified: 2012-08-13
I keep getting this error Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [OpenLink][ODBC][Informix Server]A syntax error has occurred. (-201)' in  com->Open('execute procedu...', Object(com))
I am calling the stored procedure, like this
$sqlStr='execute procedure supapp_view_orders("value","value")';
$adoConn = new COM("ADODB.Connection") or die("Can't start ADO");
 $recordSet = new COM("ADODB.RecordSet") or die("Can't create record set");
$adoConn->Open("DSN=value;Database=value;UID=value;PWD=value");
$recordSet->Open($sqlStr, $adoConn);
The connection itself works and I can run a normal query though just fine.
Am I calling the stored procedure incorrectly, or would this be an underlying syntax error in the stored procedure?
0
Comment
Question by:haloexpertsexchange
1 Comment
 
LVL 13

Accepted Solution

by:
haloexpertsexchange earned 0 total points
ID: 34240265
Never mind it, I figured out the syntax error, $sqlStr="execute procedure supapp_view_orders('value','value')"; Just swap around the single, double quotes and its fine.
Now I just have to see if I can get a stored procedure to run on a read-only connection.
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Suggested Solutions

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 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