Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Oracle ODBC driver 9.2.0.6.3 to access Oracle 9i Release 2.5 database

426853Aug 4 2004 — edited Aug 6 2004
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2004
Added on Aug 4 2004
2 comments
635 views