Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Pessimistic lock on Oracle table
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00420777
Message ID:
00421201
Views:
13
>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform