exec procedure with odbc
Posted in 2000
Topics: Connectivity: ODBC / JDBC / .NET
This is a multi-part message in MIME format. --------------38C656DA8672EB7FD9483512 Content-Type: multipart/alternative; boundary="------------7C33105B5F90A356908E14FB" --------------7C33105B5F90A356908E14FB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all , One of our customers is using informix 9.14 on NT , the application is wrriten in C++ with odbc calls. (the application works on all the databases) I want to execute procedure using an odbc call , how can I know what are the returned values of the procedure . The customer creates and opens recordset with "execute procedure ..." and then gets syntax error. They claims that when they use SQLBindColumn they get only the arguments of the procedure but not the returning values. please help!!! thx. Liat Harary --------------7C33105B5F90A356908E14FB Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <font color="#000000"><font size=-1>Hello all ,</font></font><font color="#000000"><font size=-1></font></font> <p><font color="#000000"><font size=-1>One of our customers is using informix 9.14 on NT , the application is wrriten in C++ with</font></font> <br><font color="#000000"><font size=-1>odbc calls. (the application works on all the databases)</font></font><font color="#000000"><font size=-1></font></font> <p><font color="#000000"><font size=-1>I want to execute procedure using an odbc call , how can I know what are the returned values</font></font> <br><font color="#000000"><font size=-1>of the procedure . The customer creates and opens recordset with "execute procedure ..."</font></font> <br><font color="#000000"><font size=-1>and then gets syntax error.</font></font> <br><font color="#000000"><font size=-1>They claims that when they use SQLBindColumn they get only the arguments of the procedure</font></font> <br><font color="#000000"><font size=-1>but not the returning values.</font></font><font color="#000000"><font size=-1></font></font> <p><font color="#000000"><font size=-1>please help!!!</font></font><font color="#000000"><font size=-1></font></font> <p><font color="#000000"><font size=-1>thx.</font></font><font color="#000000"><font size=-1></font></font> <p><font color="#000000"><font size=-1>Liat Harary</font></font></html> --------------7C33105B5F90A356908E14FB-- --------------38C656DA8672EB7FD9483512 Content-Type: text/x-vcard; charset=us-ascii; name="liath.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Liat Harary Content-Disposition: attachment; filename="liath.vcf" begin:vcard n:harary;liat tel;fax:09-9598980 tel;work:09-9598673 x-mozilla-html:FALSE url:www.informix.com/il org:ComSoft Technologies Ltd;ATG adr:;;3 Hagalim Blvd.;Herzelia;Israel;; version:2.1 email;internet:liath@applicom.co.il title:Pre-Sale Engineer fn:liat harary end:vcard --------------38C656DA8672EB7FD9483512--