Devart Forums

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

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.