Hi
I've connected to a datasource using ADO and OLEDB (on an Advantage server) but when I try to get the data into a cursor the access seems rather slow.

This is my code to get at the data:
cConnectString = [Provider=Advantage.OLEDB.1;]+;
[Data Source=C:\TEMP\;]+;
[Persist Security Info=False;]+;
[Advantage Character Data Type=ADS_OEM;]+;
[Advantage Server Type=ADS_REMOTE_SERVER;]+;
[Advantage Table Type=ADS_CDX]
oConn = CreateObject("ADODB.Connection")
oConn.ConnectionString = cConnectString
oConn.ConnectionTimeout = 30
oConn.Open
cSQL = "select * from sales"
oRS = oConn.Execute(cSQL)

The data goes into the RecordSet fine.

Now I want to create a report on the data (n>1000000) but when I try to transfer it to a local cursor for reporting it only seems to transfer at around 100 records every 5 seconds!

Can I REPORT FORM the data from the RecordSet without transferring to a cursor?