Re: Informix Stored Procedures (16-bit ODBC Driver)

In article <769egj$5j1$1@Nntp1.mcs.net>, "Jeff Smith" <jeff@mcs.com> wrote: > Is there a 16-bit Informix ODBC Driver available that supports calls to > Stored Procedures? > > The EXECUTE PROCEDURE command goes to the server just fine with the driver > I'm using. It's just that the procedure is not being executed. I'm able, > however, to execute the procedure directly through SQL Editor. > > Any ideas? > The driver that I'm using is the Intersolv Informix 5 2.53 16 bit driver. When I submit the following SQL to the driver using the 16 bit ODBC Test tool: create table test(col char(10)) CREATE PROCEDURE toffie () insert into test values('sofieke'); END PROCEDURE {call toffie()} select * from test I see that the select returns one row containing 'sofieke'. Pls. note that the {call <procedurename>(<argument list>)} is the correct ODBC syntax to call a stored procedure via an ODBC driver. For maximum portability it is recommended to use this syntax instead of the database specific. Should this not work I recommend trying the intersolv driver, should it work you should check the SQL syntax used with your sp. Toffie. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own