When I execute large query with ADO (MDAC 2.7) from visual basic into a DB2/AS400 database, I have the following error message when I test the property ".recordcount" or if I use the method .movelast : (I do have however all the data in the recordset)
"Data provider or other service returned an E_FAIL status".
The same query that return less rows (<4500) does not have the same problem. Incidently, the SQL query uses and "Union All" join, on other queries I do not have this problem.
Thank you for any help !
Adrian
"Data provider or other service returned an E_FAIL status".
The same query that return less rows (<4500) does not have the same problem. Incidently, the SQL query uses and "Union All" join, on other queries I do not have this problem.
Thank you for any help !
Adrian
