By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Error reading recordset from DB2/AS400

P: n/a
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.

Sep 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.