Oninit cdi / Archive
Talk to an expert →

Re: Stored Procedures

Posted in 2000

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Server Administration

P Shiller — — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------4267148E064038080B966581 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You just have to create a workspace in VB which will be connecting to the informix database and then fire the query using that workspace Example connexample.execute ("execute procedure <proc name> <parameters>") Shiller Peter Czurak wrote: > Does anyone know how to call stored procedures in Informix through VB6.0 / > ADO2.1 (What is the syntax). The stored procedure was created and can be > run in DBAccess, but I can not see the procedure through ODBC driver. > > Thanks > > Peter > pczurak@bigfoot.com --------------4267148E064038080B966581 Content-Type: text/x-vcard; charset=us-ascii; name="pshiller.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for shilller Content-Disposition: attachment; filename="pshiller.vcf" begin:vcard n:Palliyil;Shiller x-mozilla-html:TRUE url:www.shillerpf.cjb.net org:AFLWW;I.T version:2.1 email;internet:pshiller@afl.co.in title:Shiller adr;quoted-printable:;;Marol Maroshi Rd,=0D=0AAndheri(E),=0D=0AMumbay(59);Mumbai;Maharashtra;400059;India fn:Shiller end:vcard --------------4267148E064038080B966581--

↪ replying to P Shiller
Peter Czurak — — source: Informix-list mailing list archive (1991-1998)

Thank you, this works Peter "P Shiller" <pshiller@afl.co.in> wrote in message news:8lbn1t$ndc$1@news.xmission.com... > > This is a multi-part message in MIME format. > --------------4267148E064038080B966581 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > You just have to create a workspace in VB which will be connecting to the > informix database and then fire the query using that workspace > > Example > > connexample.execute ("execute procedure <proc name> <parameters>") > > Shiller > > > > Peter Czurak wrote: > > > Does anyone know how to call stored procedures in Informix through VB6.0 / > > ADO2.1 (What is the syntax). The stored procedure was created and can be > > run in DBAccess, but I can not see the procedure through ODBC driver. > > > > Thanks > > > > Peter > > pczurak@bigfoot.com > > --------------4267148E064038080B966581 > Content-Type: text/x-vcard; charset=us-ascii; > name="pshiller.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for shilller > Content-Disposition: attachment; > filename="pshiller.vcf" > > begin:vcard > n:Palliyil;Shiller > x-mozilla-html:TRUE > url:www.shillerpf.cjb.net > org:AFLWW;I.T > version:2.1 > email;internet:pshiller@afl.co.in > title:Shiller > adr;quoted-printable:;;Marol Maroshi Rd,=0D=0AAndheri(E),=0D=0AMumbay(59);Mumbai;Maharashtra;400059;India > fn:Shiller > end:vcard > > --------------4267148E064038080B966581-- >

Glossary