Problem using ALLOW_SNAPSHOT_ISOLATION

wilton_rad · 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 · 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.