Getting pessimistic about Pessimistic Locking

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

Article #5230

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

#5230

From: Alon Novy
Date: Sat, 23 Jun 2001 09:02

15 lines
1406 bytes

Hi All

I'm trying to use pessimistic locking in BCB5 / ADOExpress against a single
table in a SQL Server 7 database.

I've set cursor location to clUseServer, and LockType to ltPessimistic.

Using this combination I have found that ony one user can use the table at
any one point in time.  The second user is barred from opening a recordset
based on the table (causes time-outs when opening).
Is this a bug?  Or is there some setting which I am forgetting about?

Thank you for any clues.

Alon

Technical Details

Message-ID: <3b345876$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,cbf2e1b29c8781b6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-23 02:07:15 PST
Reply-To: "Alon Novy" <alon.novy@thinksoftware.com.au>
From: "Alon Novy" <alon.novy@thinksoftware.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Getting pessimistic about Pessimistic Locking
Date: Sat, 23 Jun 2001 19:02:02 +1000
Lines: 17
Organization: Think Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 203.32.175.13
Message-ID: <3b345876$1_2@dnews>
X-Trace: dnews 993286262 203.32.175.13 (23 Jun 2001 01:51:02 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews