VB/RDO/ODBC calling stored proc problem

[Guest.Visitor]

From a VB app using RDO I am trying to call cobol stored procedures on the AS400. We are using the DB2 Univerasal Database product to supply the ODBC drivers. I have tried many different variations but basically when I execute the OpenRecordeset method on a query which is calling a stored procedure - VB abends with a stack overflow error. Has any one done what I'm trying to do using Universal DB 5.2. If so what am I missing. As a test I've tried to call stored procs which don't exist and the same problem occurs which leads me to believe the problem is on the client side possibly with the drivers themselves.Trying to call a stored proc which returns parameters does not abend but produces ODBC errors such as "wrong number of parameters passed' or "undefined error text". Any suggestions?

[Guest.Visitor]

Got the same problems... it seems it's a bug in the server (AS400) side.... I haven't been able to call any COBOL400 SP with more than 1 parameter, the reason I think it's a server side bug is beacuse if i call any COBOL program declared as sp with more than 1 parameter from interactive sql (STRSQL) i got an error telling that I have passed an incorrect number of parameters!!!!!!!! No problem with RPG400 programs!!!!! If you have found a workraound please let me know.... you can reach me at rramirez@ebelint.com