I hope this is the right forum…If not please re-direct me. I am hoping that perhaps someone will be able to point me in the right direction and get me started. I am trying to create a stored procedure (SP) on an AS/400 that I will be called from a VB6 application. This SP is written in COBOL. I will want to pass a date range to the SP and return a record set to the application. I have used SP’s in the past but only those developed in SQL 2K. This is a bit different. I have found some guidance online but am somewhat confused as to what takes place on the VB side of the house and what is done on the AS/400 side. I have tried using the “iSeries ADO Wisard” in VB to try and create the SP. It says that it has been successful and the code has been created to acess the SP. However, when I try to invoke the call it does not seem to actually call the SP. I get no error, but when I try to access the record set in any way I get an error saying it can’t be done when it is closed. I am using Client Access to establish connectivity with the AS/400. Any help will be GREATLY appreciated and the more examples the better. Thanks for your time and help!

Chris