Problem E_Fail on with query...

[Bickle]

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 &quot;Union All&quot; join, on other queries I do not have this problem.

Thank you for any help !

Adrian

 

[MeanGreen]

It may be that one of your returned rows on a particular field(s) within your AS400 database is incomplete or corrupt. I found some information at the following link:

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_10499458.html

The link talks about an Access database, but it has the same type of erroring.

Hope this helps.

 

[Bickle]

Thanks MeanGreen , I just found the same thing on the AS400 database. In fact some tables were incomplete which caused the problem...