ADO, BCB6, MSSQL, Transactions and Isolation Levels

Article View: borland.public.cppbuilder.database.ado

Article #3193

Back to borland.public.cppbuilder.database.ado Previous Next

#3193

From: Chris Christou
Date: Tue, 03 Dec 2002 22:41

23 lines
1918 bytes

    I am running Borland C++ Builder 6.0 Professional.

    I am trying to connect to MSSQL 2000 using the ADO Connection and then
begin a transaction.  I have tried the following two different approaches:

1.    ADOConnection1->BeginTrans();
2.
    s = "begin transaction \n SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED"
    ADOConnection1->Execute((WideString) s, l_iRecAffect, l_eo);


    My problem is this: when I perform my actions inside the transaction,
such as record insertion, all other SQL Server users are locked from the
tables, as if my transaction isolation levels were set to SERIALIZABLE.

    Is there some option or setting I need to use in order to make this work
the way I think it should?  While inserting records, other users should
still be able to use the table while the transaction is still open.

  Thanks
    Chris

Technical Details

Message-ID: <3ded3257$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b127ecc80f087a1d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-03 14:40:06 PST
From: "Chris Christou" <rdzy7chdvkj001@sneakemail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO, BCB6, MSSQL, Transactions and Isolation Levels
Date: Tue, 3 Dec 2002 15:41:04 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 66.244.192.46
Message-ID: <3ded3257$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038955095 66.244.192.46 (3 Dec 2002 14:38:15 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail