PRB: Erroneous Error When Repeatedly Opening Database
ID: Q200025
|
The information in this article applies to:
-
Microsoft Visual FoxPro for Windows, version 6.0
SYMPTOMS
If you open a database located on a server numerous times from multiple Visual FoxPro 6.0 executables, then the following error randomly appears:
This file is incompatible with the current version of Visual
FoxPro. Run 30UPDATE.PRG to update the file to the current version.
This error may also occur if you are opening a Visual FoxPro 6.0 database using ADO or the Visual FoxPro ODBC driver.
RESOLUTION
Use any ON ERROR procedure, such as the one in the code example in the MORE INFORMATION section below, to trap for the spurious error.
MORE INFORMATION
This behavior does not occur in Visual FoxPro 5.0x.
Steps to Reproduce Behavior
- Set up a server machine and a client machine. Install Visual FoxPro 6.0 on the client machine.
- On the client machine, create a project and build an executable
containing the following code:
CLEAR
ON ERROR DO Errorhandler WITH ERROR(), MESSAGE()
KEY=0
OPENED=0
errored=0
DO WHILE KEY=0
OPEN DATA k:\robert SHARED
OPENED=OPENED+1
@1,1 SAY "Opened:" + STR(OPENED)
@2,1 SAY "Errored:" + STR(errored)
CLOSE DATA
KEY=INKEY(1)
ENDDO
QUIT
PROCEDURE Errorhandler (nError, messx)
errored=errored+1
@3,1 SAY nError
@4,1 SAY messx
RETRY
ENDPROC
- From the client machine, use Windows Explorer and map a drive K that
points to a shared folder on the server machine.
- Create a database on the K drive using Visual FoxPro 6.0.
This database does not need to contain any tables.
- Go to the client machine and start at least four instances of the
Visual FoxPro executable created in step 2 using Windows Explorer. You
many need to start more instances to recreate the problem.
Depending on the scenario, the error may appear quickly or it may take several minutes.
Additional query words:
kbDSupport KBDSE
Keywords : kbDatabase kbVFp600 KbDBFDBC
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbprb