Re: Error reading recordset from DB2/AS400
- From: ShaggyMoose <shaggymoose@xxxxxxxxx>
- Date: Tue, 11 Sep 2007 08:35:24 -0700
Set adorecSet= _
adoConn.Execute("{Call libraryname.PR_TEST()}", ,adCmdText)
Thanks for you help. I tried the above, and it called the stored
procedure and returned a record set. However, there are two problems:
1. The cursor doesn't seem to know the record count (eg.
adoRecSet.RecordCount = -1).
2. I still get the same error message on the first adDBDate field when
the value is not NULL.
So, back where I started. Its very confusing to me that I am doing
basically the same thing via different methods, yet the result is
always different (well, broken in different ways).
.
- Follow-Ups:
- Re: Error reading recordset from DB2/AS400
- From: Bob Barrows [MVP]
- Re: Error reading recordset from DB2/AS400
- From: Ralph
- Re: Error reading recordset from DB2/AS400
- References:
- Error reading recordset from DB2/AS400
- From: ShaggyMoose
- Re: Error reading recordset from DB2/AS400
- From: Stephen Howe
- Re: Error reading recordset from DB2/AS400
- From: ShaggyMoose
- Re: Error reading recordset from DB2/AS400
- From: Bob Barrows [MVP]
- Error reading recordset from DB2/AS400
- Prev by Date: Re: Error reading recordset from DB2/AS400
- Next by Date: Re: Error reading recordset from DB2/AS400
- Previous by thread: Re: Error reading recordset from DB2/AS400
- Next by thread: Re: Error reading recordset from DB2/AS400
- Index(es):