ADO on Oracle: recordset unmanageable

Tech-Archive recommends: Fix windows errors by optimizing your registry

hi, i have this problem...
i'm using ADO on Oracle and sometimes when i open recordsets with
adOpenStatic, adLockOptimistic the recordset results unmanageable...
if i check the EOF property, the error "3704 Operation is not allowed
when the object is closed" pops up... but non always, some recordsets
works correctly...

if i don't specify any properties while opening the rst everything
goes ok...

any suggestions?
thank you
m.
.

Relevant Pages

  • ADO on Oracle: recordset unmanageable
    ... i'm using ADO on Oracle and sometimes when i open recordsets with ... if i check the EOF property, the error "3704 Operation is not allowed ... but not always, some recordsets ...
    (microsoft.public.data.ado)
  • Re: strange behavior with copyFromRecordset/ADO
    ... recordsets, although it seemed to me that it occured when adding a workbook ... I typically run XP, using ADO 2.8. ... > oracle db using ADO. ... > CopyFromRecordset again for improved performance. ...
    (microsoft.public.excel.programming)
  • Re: Connection to Oracle
    ... Use the ADODB class for connections and RecordSets. ... > I have moved Access XP tables to Oracle 9i. ... > VBA code, Can I use one connection variable for opening ...
    (microsoft.public.access.externaldata)
  • Re: BDS2006 and FireBird
    ... Bernhard Geyer wrote: ... uses Oracle) ... what cursor library do you use for recordsets then? ... including the "antispam" part. ...
    (borland.public.delphi.non-technical)
  • Is this the right method for opening recordsets in ADO ?
    ... What is the good way to open recordsets in ADO. ... connection object just one time and have all recordsets when they are ...
    (microsoft.public.vb.database.ado)