IsolationLevel workaround?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I would like to use the SQL 2005 SNAPSHOT isolation level. I understand
that the ADO IsolationLevelEnum has not been updated for SQL 2005.

I thought it would be OK if I left the connection set to
cn.IsolationLevel=adXactReadCommitted, and then I issued a statement on the
connection like:

cn.Execute('SET TRANSACTION ISOLATION LEVEL SNAPSHOT');

However, ADO is kind enough to set the isolation method back to
ReadCommitted whenever I begin a transaction. And, I am not allowed to
change the isolation level to SNAPSHOT inside a transaction if the isolation
level was not SNAPSHOT at when the transaction was started. Argh...

So I thought if I set cn.IsolationLevel=adXactUnspecified, then issued the
Execute statement as above to set the isolation level for the connection
that I would be OK. However, then I get errors like:

"Neither the isolation level nor a strengthening of it is supported."

Is there any way to get ADO to use the SNAPSHOT isolation level? Or, is
there at least any way to get ADO to NOT set the isolation level at the
start of a transaction so that I can set the isolation level myself?

Sincerely,

David Rueter
drueter@xxxxxxxxxx


.

Relevant Pages

  • Re: Oracle Isolation Level and ADO
    ... These COMs access to an ... > Oracle DB with ADO. ... > Is the explicit LOCK useless in this code? ... > isolation level impact only on read locks. ...
    (comp.databases)
  • Re: IsolationLevel workaround?
    ... In the end I opted not to use the ADO transaction methods (i.e. ... This allows me to use the SNAPSHOT isolation level. ... Is there any way to get ADO to use the SNAPSHOT isolation level? ...
    (microsoft.public.data.ado)
  • Re: Oracle Isolation Level and ADO
    ... >> Oracle DB with ADO. ... > object to specify an isolation level, ... > so it is similar to EXCLUSIVE locking. ...
    (comp.databases)
  • Oracle Isolation Level and ADO
    ... Oracle DB with ADO. ... BEGIN TRANSACTION ... Is the explicit LOCK useless in this code? ... isolation level impact only on read locks. ...
    (comp.databases)
  • Re: IsolationLevel workaround?
    ... cn.Execute('SET TRANSACTION ISOLATION LEVEL SNAPSHOT'); ... ADO is kind enough to set the isolation method back to ... ReadCommitted whenever I begin a transaction. ...
    (microsoft.public.data.ado)