Home > Software engineering >  Cursorlocation and isolationilevel about CONNECTION object
Cursorlocation and isolationilevel about CONNECTION object

Time:09-24

The CONNECTION object in the VB cursorlocation and isolationilevel Settings, how don't see any difference between
1. To set for aduseclient cursorlocation, first set isolationilevel respectively from the read uncommitted to the serialization results are the same,
2 for cursorlocation set to aduseserver first, and then respectively set isolationilevel from the read uncommitted to the serialization results are the same,
Such as: a record number of field values is 1
To set up A computer aduseclient and read uncommitted, B computer set up aduseclient and read uncommitted
A changed value of 5 computers and use the updatebatch, but not committed, B computer open, or the original value of 1. (in the SQL query analyzer, if the transaction isolation level is the read uncommitted read value is 5)
Only A computer with A committed, B computer open value is the change after 5.
Change the cursorlocation whichever in VB, and isolationilevel change which is the same as a result, please grant instruction,

In addition, I in the SQL transaction isolation leve is set to the read committed why use DBCC useoptions will display the read committed the snapshot
  • Related