Kbase P39396: SQL-92: How to set the transaction isolation level within a Visual Basic application using ADO
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2007 |
|
Status: Verified
GOAL:
How to set the transaction isolation level within a Visual Basic application when connected via SQL-92 interface to a Progress 9.X database ?
GOAL:
How to change the transaction isolation level of a SQL-92 connection?
GOAL:
What are transaction isolation levels?
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
Progress 9.x
FIX:
Set the IsolationLevel property of the Connection Object to the appropriate value then start and stop a transaction. The new IsolationLevel settings will not work until a new transaction and started.
The following sample code shows how to start and stop a "dummy" transaction so that the new isolation level takes effect:
Some_ADO_Connection_Object.IsolationLevel = 256
Some_ADO_Connection_Object.BeginTrans
Some_ADO_Connection_Object.RollbackTrans