RE: Mysterious lockout in

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Roger:

Have you tried running Filemon (from www.sysinternals.com) to see if you
can tell what has a file lock on the file? Have you tired opening a DOS
prompt and typing Net Files to see who has giving files open on the server?

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003





>I am getting locked out by something but I don't know what.

>I am running an ODBC query on a Foxpro db (a bunch of dbf files with
>the MS VFP ODBC driver pointing at the directory). The db is a 3rd
>party package and I am running my own SELECTs on several of the tables.
>The 3rd party application is shut down.

>One of the SELECTS never returns, as if it is waiting for a lock to
>come free. I have rebooted the db machine, shut down all the other
>machines in sight (they access this db as well) and still it locks. I
>copied the whole thing to another machine, set up a different data
>source and ran my SELECTs and they all work fine there (they take under
>a minute). This tells me it isn't a file corruption.

>So something on that db machine seems to be holding a lock on the dbf
>files and it survives a reboot. There is nothing else running on the db
>machine. It has WinXP installed and the ODBC driver version is
>6.01.8630.01.

>Any ideas? I'm thinking there is some service that 'remembers' locks
>after a reboot, but that doesn't seem likely. They run MacAffee and I
>tried it with that stopped. Still locking.



.

Relevant Pages

  • Re: Mysterious lockout in
    ... There is no type of lock that will persist after a reboot. ... > party package and I am running my own SELECTs on several of the ... It has WinXP installed and the ODBC driver version is ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Waiting for lock
    ... It occurs when foxpro need to lock a record in a file, ... Commands such as REPLACE ALL need to implicitly FLOCK a table to perform. ... Because the field Vendors.cVendName was involved in a READ, Foxpro would ... issue or a loss of network connectivity for a split second. ...
    (microsoft.public.fox.programmer.exchange)
  • OS lock up Win XP
    ... Next lock up could be in one hour ... >Now and the during reboot she gets a checksum error... ... problem with my video driver Nvidia GeForce 440 MX,kept ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Windows XP w/Dual Processor
    ... > reboot without warning? ... >> My pc will lock up. ... I just bought/built a dual AMD Opteron workstation. ... Geforce4 MX440 64MB AGP Card ...
    (microsoft.public.windowsxp.general)
  • Re: sync, reboot, and corrupting data [was Re: 2.6.29 -mm merge plans]
    ... It means that you cannot reboot because reboot does sync. ... Well, ok, data loss is expected in such case. ... Ok I suppose with that Nick's lock is actually ok, ...
    (Linux-Kernel)