Re: How to do pessimistic locking in oracle with vb4

 In article <328C8BC2.57D7_at_generation.net>, Eric Leblanc  <infosile_at_generation.net> wrote:  

>I'm accessing an oracle 7.1 database in vb4, using an openlink lite
>driver. I use a resultset to do some editing on a table. When a user
>edit a record, I want this record to be locked, so the other users can't
>modify this record. I tried to open my resultset with the rdConcurLock
>locktype, but I received the error :
>S1C00 : [Microsoft][ODBC Cursor Library] Cursor library not capable

Try setting your RDO Environment Object's CursorDriver property to rdUseServer. This forces the RDO to use server side cursors instead of ODBC side (which evidently the driver is not capable of..)

D.M.(Mike) Mattix
Monsanto Company
Luling, LA 70070
dmmatt_at_monsanto.com Received on Mon Nov 18 1996 - 00:00:00 CET