Problem using ALLOW_SNAPSHOT_ISOLATION

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wilton_rad
Posts: 4
Joined: Fri 10 Sep 2010 14:37

Problem using ALLOW_SNAPSHOT_ISOLATION

Post by wilton_rad » Fri 10 Sep 2010 14:46

Hi, i'm set property IsolationLevel in object msconection for ilSnapshot

apply command my database.


ALTER DATABASE mydatabase SET ALLOW_SNAPSHOT_ISOLATION ON

when conect in aplication return error:
http://www.radinfo.com.br/instaladores/erroisolationlevel.jpg

using SQL Server 2008 enterprise version 10.0.2531.0
using sdac version 4.80.0.58

if conect in server my aplication open correct.

thank you

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 13 Sep 2010 10:33

This problem is connected with the work of standard OLEDB provider, because it doesn't support the ilSnapshot isolation level. To solve the problem you should use the SQL Native Client provider. For this set the TMSConnection.Options.Provider property to the prNativeClient value.

Post Reply