haloexpertsexchange
asked on
I get a syntax error trying to call an informix stored procedure.
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=v alue;UID=v alue;PWD=v alue");
$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?
I am calling the stored procedure, like this
$sqlStr='execute procedure supapp_view_orders("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;
$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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.