Visual Foxpro tables locked by aspnet_wp.exe process

Hot Topic

Help
editbox control snaps.
With ... EndWith
Deleted records still getting fetched
Excel validation
=SYS(1037) on VFP90 no longer allows printer changes
_urlcombobox problem
how do i get a result in 4 tables in SELECT- SQL command?
editbox programmatic change
can i use SQL sort by special expression?

Visual FoxPro

Two questions (about database structure & controls)
foxpro dos to visual foxpro 9 conversion
Auto-shutdown
class called
Clearing a cursor
cannot update cursor < > since it is read-only
All the sudden a batch of records (that were already in the table) are appended again?!?
VFP 9.0 SQL worthless under a non client server network?
MSGraph.Chart.8 control
Open table exclusively?

Visual Foxpro tables locked by aspnet_wp.exe process

Hi!

I'm currently using Visual Foxpro 9.0, .NET Framework 1.1, Visual Studio 2003 (VB) for web development. Everything's fine except this little 'quirk'. When i'm doing some testing, and try to open a table with VFP, i have the following message :File access is denied .... with the path of the table. The first solution i found (not very practical in a running environment) is to run a cmd-line and type iisreset to release any process or handle associate with the database. The second solution i found was to run Sysinternals Procexp, click on the aspnet_wp.exe process and close all the handles on the databases and tables. This is a less radical solution than doing iisreset, but not very practical. I'm looking for a better solution. Any help will be appreciated!

TIA


Answer this question

Visual Foxpro tables locked by aspnet_wp.exe process

  • gulatis

    Tongue TiedTongue TiedTongue Tied

    I found the problem, and it's the guy who typed this message (myself). To make a brief story, i've created a public class, and declared a public shared OleDbConnection object.... Thanks again for the help!

  • dano992

    Hi Cetin!

    I'm not opening my VFP tables exclusively or calling a VFP COM object. This is the connection string i'm using : Provider=VFPOLEDB.1;data source=PathToMyDatabase.dbc;Exclusive=No;BackgroundFetch=No; I even take a look at the database properties and tables properties and everything seems ok. I will send you by mail a screenshot, maybe it will be easier for you to understand my problem....

    TIA

  • wendallsan

    I don't know a setting in VFPOLEDB as "Exclusive" and "Backgroundfetch". Instead use Mode (default Share,deny none). ie:

    "Provider=VFPOLEDB;Data Source=c:\MyPath\MyDB.dbc"

  • Sandra Geisler

    Check help file. It has "Getting Started","Using Visual Foxpro","Samples and walkthroughs" sections.

  • pgiuseppe

    Are you opening VFP tables somewhere exclusively Are you calling a VFP COM object that doesn't derive from a session class (or a session class where datasession is not set to 2)

  • Jason Smith - MSFT

    Hi Cetin!

    No improvement at all.....

    Thanks!

  • Tomas W

    hey sorry i want to know if you have some tutorial about visual foxpro, im beginner so i want to learn visual foxpro,,,



  • Visual Foxpro tables locked by aspnet_wp.exe process
Answer this question