Re: read dirty

Posted in 2000

Apostolos Varnas — Sun, 23 Jul 2000 19:35:34 +0300 — source: Informix-list mailing list archive (1991-1998)

Peter Czurak wrote: > I am developing an application in VB6.0 using ADO2.1. I want to Set > Isolation dirty read, How can I do that through ADO? > > Thanks > > Peter > pczurak@bigfoot.com Set the IsolationLevel Property of your ADODB Connection to the value adXactReadUncommitted. You must also start and end a dummy transaction in order for this to take effect for your ADODB Connection. See Example Code below: Set ODBCConn = New ADODB.Connection With ODBCConn ... ' Set Isolation Level to Dirty Read for the Connection .IsolationLevel = adXactReadUncommitted .Open ' Open a dummy transaction in order for the isolation level to ' take effect .BeginTrans .CommitTrans End With HTH Tolis Varnas -- V+K Relational Solutions mailto:tvarnas@compulink.gr Deligiorgi 26 mailto:tvarnas@orbit.de 546 42 Thessaloniki Voice: +30-31-820270 Greece Fax: +30-31-865463