Re: ADO -> Oracle

Georg Schulte Althoff wrote:
>
> Without looking into my VB-projects where I used ADO I think it has to do
> with the properties of your recordset-object.
> Try to change the values of CursorLocation and CursorType. The MSDN
> documentation will help you to find out about the possible combinations. I
> remember that I read an article about it.
>
> Georg
>
> Kenneth C Stahl <BlueSax_at_Unforgettable.com> schrieb in im Newsbeitrag:
> 38198B2A.AC793FD_at_Unforgettable.com...
> > I am learning how to use ADO to connect to an Oracle database.
> >
> > After defining a connection with DRIVER={Microsoft ODBC for Oracle}, I am
> > able to retrieve records into a record set and process them sequentially.
> > However, in attempting to add new features to the program I tried to do a
> > rs.movelast followed by a rs.movefirst and received an error message:
> >
> > Run-time error '-2147217884 (80040e24)
> > The rowset does not support fetching backwards.
> >
> > Is this a problem with:
> > 1. Oracle?
> > 2. ODBC?
> > 3. The particular version of ODBC on my system
> > 4. ADO?
> > 5. ADO 2.1?
> >
> > Is there anything that I can do to get this functionality?

Found it. I had to

set rs.CursorType = adOpenDynamic

after that it worked gangbusters. Received on Fri Oct 29 1999 - 09:33:41 CDT