problem with reading records from DB2 table

[sqadri]

Could someone please help me with this issue. I am trying to read all the data in all the columns of a table and the script leaves out some records, e.g. if I have 100 rows only 95 are read. Is theer a limit as how many records can be read.

Code:

DB2Cn.Open DB2ConnStr
Set getDB2Connect = DB2Cn
If getDB2Connect.Errors.Count = 0 Then
Set rs = DB2Cn.Execute(query,,adExecuteNoRecords)
colCount= rs.fields.count  ' to retrieve the no. of columns in recordset
rows = rs.fields(0).value 'rs.recordcount

Then I am using a for loop to get each row data.

Thanks,
Sqadri