Transaction Isolation Level: RepeatableRead

[ccy]

Hi,

I am evaluating the corelab DBExpress driver for MSSQL. I am using Delphi 2006. I try to do this:

with FConnection.Params do begin
Values['SQLServer TransIsolation'] := 'RepeatableRead';
end;

But It seems doesn't work at all. Can MSSQL Server support RepeatableRead?

I tried the Interbase/Firebird and it works as expected.

[Jackson]

MS SQL Server supports REPEATABLE READ transaction isolation level and such
code works well (but be careful, dbExpress applies parameters only on connect).
You can see it in profiler. For more information about transaction isolation levels please see MSDN.