What providers do pessimistic locking?



Is there an OLEDB provider that will support pessimistic locking of
resources over the network, much like Mutexes lock resources on a local
machine?

I was looking to OLEDB/ADO to provide that, as we already use it for an
Access database. I was going to set up another Access database with record
locking as a doorway to the restricted resources. However, I realize now
that Jet does not support CursorType = adOpenDynamic, but changes it to
adOpenKeyset which does not see changes made by other users.

Maybe I am missing something -- is there is another way to lock over the
network using a completely different technique? Please let me know any
ideas.



.



Relevant Pages

  • Re: proper naming of a domain
    ... The primary reason for not being able to see resources/browse etc during a VPN is that the IPschema of remote network is the same as the LAN that you are connecting to. ... from home I can Connect to the server and it tells me that I am connect to ... resources it tells me that the path cannot be found. ...
    (microsoft.public.windows.server.sbs)
  • Re: Detect open windows shares?
    ... to know their names is to browse the network neighborhood. ... The WNetOpenEnum function starts an enumeration of network resources or existing connections. ... RESOURCE_CONTEXT Enumerate only resources in the network context of the caller. ... To obtain a description of the error, call the WNetGetLastError function. ...
    (comp.lang.perl.misc)
  • [Full-Disclosure] Authorities eye MSBlaster suspect (long reply)
    ... Although segments of that network are cordoned off (and I ... the incident which requires the response. ... issues that that the old (and normally less secure) systems shall vanish. ... Recall that security balances against usability and resources. ...
    (Full-Disclosure)
  • Re: Publishing Problems with Win XP and FP 2002 on a school network
    ... but that doesn't preclude someone from accessing network ... resources if they have domain credentials. ... I'm certain that if you have a Windows 98 client, and you try to access a ... the FrontPage website's folder. ...
    (microsoft.public.frontpage.client)
  • Re: Sharing Resources on LAN
    ... > can't get resources sharing going, ... Permanently disable ICF on all XP PCs. ... R/W access from the network. ...
    (microsoft.public.windowsxp.network_web)