Using Oracle ODBC driver 9.2.0.6.3 to access Oracle 9i Release 2.5 database
426853Aug 4 2004 — edited Aug 6 2004I am using ADO (from ASP) to connect to Oracle 9.2.5 database. ODBC driver used is 9.2.0.6.3.
I can use Server side cursor (default) in ADO with cursor type set to "Static". But when I try to use cursor type "KeySet", it doesn't work, The no. of records returned is -1 and only a single record is displayed in database.
I am not able to use RecordSet.Resynch with "Static" cursor.
Is there any way to make "KeySet" cursor type work with Server type cursor? Or use Recordset.ReSynch on "static" cursor?