I don't have a problem retreiving record sets. Actually calling the
procedure is what I'm having a problem with. The procedure calls fail with
an error of not a valid SQL command when I use a statement like
sql = "{CALL ""LIST VOC""}"
or in my case I'd like it to be a subroutine but this is something like
one of the sample from the docs.
Well if I get an answer I'll pass it along
Vance> Hi, Mr. Jordan. > > I've been considering using ODBC instead of UniObjects for our web > project, too, but am unfamiliar with . Could you please include a small, > very generic, code snippet to show what you mean here. It would be much > appreciated! > > Thanks, > Dave > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL > Sent: Tuesday, July 26, 2005 6:21 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UVODBC procedure call from VBScript > > > To return a recordset from a UniBasic subroutine to an ODBC call you need > to > load data into the @HSTMT variable in the UniVerse Basic Subroutine. > > Regards > David Jordan > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, 27 July 2005 6:31 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] UVODBC procedure call from VBScript > > Hi all, > > I'm trying to convert a web app from Sybase to UV. I've been attempting to > get a vbscript app to call a subroutine as a stored procedure. I am able > to connect to the database using the OLE provider and retrieve recordsets. > I'd like to be able to execute stored procs as well. IBM provided me with > a VB sample to call a subroutine but I can't seem to implement it in > VBScript. I've gone over the docs a million and one times and still can't > seem to see what I'm missing. Does anyone have any samples, calling a > subroutine through ODBC that would return a rescordset to the script that > they would be able to share ? > > Thanks for any help, > > Vance Forste > -------------------------------------------- > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
