Re: adLockReadOnly problem with SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 03/08/05

  • Next message: Wart: "Re: ado error 3001" 
    Date: Tue, 8 Mar 2005 12:53:39 -0000

    > which runs fine. However, when other users try and update "PropertyImage",
    > Enterprise Manager shows that my app is blocking their update. Since my
    app
    > can take a while to run, it times them out.
    >
    > Shouldn't the lock type be "read only" by default, so no blocking can
    occur.

    It is readonly by default and the chances are it is readonly.
    But even readonly does not mean it will not block others.

    > Is there any sense in disconnecting the recordset to avoid blocking other
    > users. I never need to update the date, just read it

    You won't be able to disconnect the recordset.
    You have made a server-sided, forward only cursor.
    I imagine that this blocks the updates by others of these tables as the
    server is _still_ delivering the data.

    Switch to a client-sided cursor.
    You can disconnect then.

    I would suggest reading up on cursortypes

    Stephen Howe

  • Next message: Wart: "Re: ado error 3001"

    Relevant Pages

    • Re: adLockReadOnly problem with SQL Server 2000
      ... > Enterprise Manager shows that my app is blocking their update. ... You won't be able to disconnect the recordset. ... forward only cursor. ... server is _still_ delivering the data. ...
      (microsoft.public.data.ado)
    • Re: Cannot open Access table with ADO or BDE/ODBC
      ... No event handlers present. ... I wrote a tiny app just for testing this ... problem with server side cursor? ...
      (borland.public.delphi.database.ado)
    • Re: VB App fails when log reaches 65536
      ... Are you sure it's creating a client-side cursor? ... I haven't done a database app in a while, but IIRC, when a client-side ... the db server does nothing except hand off the entire db to ... the client program and then the client app generates the query locally. ...
      (microsoft.public.vb.general.discussion)
    • Re: Homegrown synchronization
      ... to check for update files in the Import DropBox for the server. ... similar to the import code used to update a remote backend). ... code to close the "sync" app. ... synch app, but only one at a time would be able to do synchs. ...
      (microsoft.public.access.replication)
    • RE: Beginners Questions
      ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
      (microsoft.public.dotnet.distributed_apps)