And when it comes to return recordsets - they aren't returned to Parameters Collection. You must use ADODB.Recordset Object and then fill it with results from your command - something like below
Set rsRecordset = cmdCommand.Execute Just the way you do it with MS SQL Server. And it works fine on my side :)) Of course remember to upgrade your ODBC driver, if my memory doesn't fail starting with ver. 7.3.024 you get possibility to use procedures returning resultsets (or rather recordsets - in VB convention). Kind regards, Marcin Pytel U�ytkownik "Zabach, Elke" <[EMAIL PROTECTED]> napisa� w wiadomo�ci B9A2DDA03044D311BBD40008C75D69680DBAB4D0@dewdfx24">news:B9A2DDA03044D311BBD40008C75D69680DBAB4D0@dewdfx24... Tomasz Kantecki wrote: ..... > Another question concerns DBPROC: > - is it possible to return recordset from DBPROC? how shall I do it? > - I guess the return data is retrieveable via Parameters collection? I checked the archive http://listserv.sap.com/pipermail/sapdb.general/2002-March/011334.html http://listserv.sap.com/pipermail/sapdb.general/2002-October/014799.html http://listserv.sap.com/pipermail/sapdb.general/2002-March/011347.html and the newest reference manual (7.4) http://www.sapdb.org/7.4/htmhelp/a7/41ee11605911d3a98800a0c9449261/frameset. htm Does this answer you question? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
