Oracle, Transactions and ASP/ADO

From: Enrico Luciano <e.luciano_at_NOSPAMMMwirecom.it>
Date: Mon, 18 Feb 2002 19:34:10 GMT
Message-ID: <SGcc8.17921$eD3.723582@twister1.libero.it>

Hi,
I need to understand how to set ASP property values in order to get some functionalities in Oracle transatcions/locking beaviour (ok, the last word is wrong, but you'll understand...)

As an exaple Oracle has the following commands/directives:

SET TRANSACTION, which can be setup to READ ONLY, READ WRITE, USE ROLLBACK SEGMENT
- FOR UPDATE directive in DECLARE of a cursor definition
- LOCK TABLE command, with ROW SHARE, etc etc modes

What I need is how to set values for porperties in Connection, COmmand Recordset object in order to get what I want...

i've found that there are at least 3 Properties of these objects that can be useful (IsolationLevel, Mode, LockType) but I can't understand how to set them in order to do what I want...

Can someone please tell me where to find some useful documentation?

Thank you in advance... Received on Mon Feb 18 2002 - 13:34:10 CST