Recordset paging and Oracle 8.04

[thehutt]

I tried to implement recordset paging in ASP using an Oracle 8.04 database. I get the following error:

>ADODB.Recordset error '800a0cb3'
>
>The operation requested by the application is not supported by the provider.
>

It appears to me that the Oracle ODBC driver I am using does not support recordset paging. Does anyone know of either:

1. A solution to this problem with my current ODBC driver
2. An Oracle 8.04 ODBC driver that does support record paging

My code looks a lot like this:

http://www.asp101.com/samples/viewasp.asp?file=db_paging.asp

Except that I connect to an Oracle 8.04 database instead.
Any help is much appreciated.

 

[thehutt]

I found the solution to this error, I had not set my cursorlocation.

CursorLocation=3