How to change Transaction Isolation Level



Hi,
I want my application to use the Read uncommited transaction isolation
level, but i can not set it.
If I set the IsolationLevel ot the TADOConnection, this isolation level is
taken into account only when i start a new transaction.
I tried to execute a script after opening the connection like
dbConnection.Execute('SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED');
but this did not help as well.
The point is that most of the time the users do just SELECT and I want to
avoid shared locks.

Thanks in advance.
--
Ivan Slavev
General Manager

InnovaSys Ltd.
157 Cherni Vruh blvd.,
1407 Sofia, Bulgaria
mobile: +359 88 666 999 3
e-mail: i.slavev@xxxxxxxxxxxxxxxx
online: www.innovasys-bg.com

Best Regards,

Ivan Slavev


.