Microsoft KB Archive/242982

= PRB: VFP Hangs on Windows 98 When Using Novell NetWare Client After Exceeding the Number of Available File Handles =

Article ID: 242982

Article Last Modified on 5/10/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q242982



SYMPTOMS
Issuing the APPEND FROM  TYPE XL8 command makes Visual FoxPro either disappear or produce an error. In Visual FoxPro 6.0 running under Windows NT 4.0, the following error message might appear before the application closes:

Fatal error: Exception code=C0000005

After selecting OK, Visual FoxPro disappears. In Visual FoxPro 6.0 Service Pack 3 running under Windows NT 4.0, FoxPro simply disappears after executing the APPEND FROM command. No error message appears.

In Visual FoxPro 6.0 Service Pack 3 running under Windows 98, the following error appears:

Microsoft Excel file format is invalid.



RESOLUTION

 * 1) Open the Network Applet in the Windows Control Panel.
 * 2) Select the Novell NetWare Client from the network components and click the Properties button.
 * 3) Select the Advanced Settings tab of the Novell NetWare Client Properties dialog.
 * 4) Select the "Use Extended File Handles" property.
 * 5) Change the "Setting" value to "ON."



MORE INFORMATION
The Novell NetWare Client for Windows 95 release 3.0 and greater, has a new Use Extended File Handles property that has been added to the Advanced Settings. The default setting for Use Extended File Handles is "OFF."

Steps to Reproduce Behavior
 Launch Visual FoxPro and set the default directory to a directory on a Novell Netware Server.  Create a program file named "DEMO.PRG" with the following code: CLOSE ALL SET SAFETY OFF IF !FILE("base.dbf") CREATE TABLE BASE (basekey c(10), memofld m)  INSERT INTO BASE (basekey,memofld) VALUES ("0000001","this is ;   a test") INDEX ON basekey TAG basekey OF BASE ENDIF FOR i=1 TO 100 thisstr="file"+ALLTRIM(STR(i)) SELECT DISTINCT * FROM BASE INTO TABLE &thisstr SELECT (thisstr) INDEX ON basekey TAG basekey OF &thisstr NEXT SET SAFETY ON                    Run the DEMO.PRG file. When the following error message appears, click Cancel:

Too many files open

 From the Command window, type DIR. The machine may hang at this point.</ol>

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by John Desch, Microsoft Corporation.

Keywords: kbcodesnippet kbprb kbpending KB242982

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.