Yes, this is cross posted to microsoft.public.data.ado, but I figured
there are two distinct parts to this with different audiences.
I am trying to use ADODB to return a recordset from a DB2 stored
procedure on AS400. All the procedure does is return a cursor for
SELECT * FROM. I have tried both the "IBMDA400" and "Client Access
ODBC" drivers. The first returns an empty recordset (incorrect), while
the second returns the expected number of records. Unfortunately,
attempting to read the field values produces the error "multiple-step
operation generated errors" at the first adDBDate field. The contents
of the remaining fields after this point are garbled. However, I am
still able to read the other information for all fields (name, size
etc).
Note that if I use the ADODB.Command to do the SELECT * FROM directly
(adCmdText), the resulting recordset works perfectly under both
drivers!
Is there any problem with interpreting recordsets obtained directly
from AS400/DB2 stored procedures, or specifically the adDBDate data
type? Thanks.