Re: Accessing Sored Procedures using VB thru ODBC

Letchu.MAL@malaysia.solectron.com wrote: > > Hi INFORMIXers, > I need to know whether it is possible to access the stored > procedures on Informix using Microsoft Visual Basic(3.0 or > 4.0) through an ODBC driver. > > Thanks. > > letchu > letchu.mal@solectron.com Yes, but it depends on the driver. Some drivers will support this by accident (you can issue stored procedure calls and retrieve results through a cursor) and others provide specific support for stored procedures via the ODBC interfaces for stored procedures. The ODBC interfaces for stored procedures are quite complicated and many driver vendors have decided to ignore implementing them. Most of the drivers I have used will allow you to execute a stored procedure and retrieve the results through a cursor. They usually don't provide support for return values. Some of the major vendors are promising support in their next release. Some of those releases should already be available. I recommend contacting them to find out. Try Intersolv and/or Visigenic. release of the drivers