Re: snapshot isolation level

As I said, the ability to set this really depends on the Provider. For
example, pre-2005 SQL Server did not have snapshot isolation: it was newly
introduced in SQL 2005, so the SQLOLEDB provider will not be able to use it,
whereas the new SQLNCLI provider should be able to. You need to look for the
documentation for that provider to see if it can do it.

Jan Nitecki wrote:
Hello,

Unfortunately MDAC documentation has no reference to Snapshot
isolation, so there is no relevant enum.

Best regards,
Jan Nitecki

"Bob Barrows [MVP]" wrote:

Fotis Mylonas wrote:
Hallo all,
suppose i have the oldfashioned:
Set cnSQL = Server.CreateObject ("ADODB.Connection")
Is there a way to use snapshot isolation level in an old (prior
.Net) connection object (ado 2.7)?

Maybe. It depends on what database and provider you are using. It
sounds as if you don't have access to the ADO documentation which
can be found here:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscadoapireference.asp

Look for the Isolationlevel property, as well as the
IsolationLevelEnum enumeration.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Transaction Isolation Level
    ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Re: Transaction Isolation Level
    ... the isolation level you should use is snapshot isolation. ... You may see different last names for the same employee ID if the query ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: SnapshotIsolation Level and Com
    ... COM+ often uses distributed transaction to talk with SQL Server. ... We recommend that you use "read committed snapshot isolation" instead of ... > Isolation level in SQL Server 2005 and have a question. ...
    (microsoft.public.sqlserver.server)
  • RE: copied music cds have a skip in last 18 seconds
    ... If installing all missing Windows Updates doesn't fix your problem ... xiowan.......in tucson ...
    (microsoft.public.windows.mediacenter)