ADO limiting the Number of Recordsets OPen

Hi

I am using ADO recordsets with SQL SERVER

Following is the code

Set PASS_db = New Connection
PASS_db.CursorLocation = adUseClient
PASS_db.Open "Provider=SQLOLEDB;Server=troysql;Database=mmsdata1", "sa", ""


Set Report_RS = New Recordset
cSqlString = "SELECT BookingId, LDate, WeekDay, ClientId,StreetNum,OnStreet, CITY,BookingType, SubtypeAbbr, AdaCode, LastName, FirstName FROM BookingView1"

'Report_RS.Filter = cRepCriteria
Report_RS.Open cSqlString, PASS_db, adOpenDyanamic, adLockReadOnly


This Particular table has more than 1 million records.

When the recordset Open time it fails and gives error number 6.

I thought i can open 10000 records and process it and then get next batch of 10000 records

Thanks


Sridhar

[msdnexpert]

Kindly elaborate the error message received