Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO Pessimistic lock on Oracle table
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00420777
Message ID:
00421201
Vues:
12
>I'm trying to get an server side ADO Recordset from an Oracle table with the LockType = adLockPessimistic, but it does not work. Can I not do this with Oracle?

What other settings are you trying? Some recordset options are incompatible with each other. When this happens, the provider just gives you a forward only, read only rs without giving an error message. Check the settings after the rs is open, and also check the Supports method of recordset to see if the provider supports the options you are trying to set.

Just as a guess, do you have permissions to request a lock on the result set you are requesting?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform