473,320 Members | 1,940 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error reading recordset from DB2/AS400

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
0 1520

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bill | last post by:
I currently connect to two servers. One is IIS, that runs my asp and sql server, and the other is an AS400, that also cranks out data. Sometimes I have to wait for data I submit to the as400 to...
1
by: Logan | last post by:
I am trying to transfer with dts a table of As400 into a db sql-server. But i receave un error (2147217865) With Access i can import the table with the same ODBC. You have some suggestion...
6
by: Rowan | last post by:
Hello, I have been trying to solve this problem for a couple of weeks now with no progress. I created a package that works when it runs from my computer but when it runs as a scheduled job, it...
0
by: alan_sec | last post by:
Hi. Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that is installed on windows 2000? I' m trying to...
1
by: Norma | last post by:
I am trying to split a database that I created at work. It has local tables, linked tables to other Access databases on our server and also linked tables to an AS400 database in another state....
0
by: D.Saravanan | last post by:
I am using asp.net to connect to the DB2/400 database on the AS400. When I connect through windows forms or console application, the connection works fine. But when I connect through asp.net I get...
0
by: Manuel Arroba | last post by:
asp.net oledb command parameter error calling an as400 program Hi... I have an as400 program that I can call it directly and it works: variable= "xxxx" sql = "CALL METSIGOP.SIGOPRC ('" +...
5
by: Amaryllis | last post by:
I'm trying to call a CL which is located on our AS400 from a Windows application. I've tried to code it in different ways, but I seem to get the same error every time. Does anyone have any clue...
102
by: BoogieWithStu22 | last post by:
I am running into a problem with a web page I have created when viewing it in IE6 on some machines. The page has a database lookup. The user enters an account name or number and clicks a lookup...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.