Unable to Access FoxPro Databases on Netware 5 Server from IIS 5.0 (271214)

RESOLUTION

1. On the IIS computer that is attempting to communicate with Microsoft FoxPro, install Novell Netware Client for Windows NT (Required). During setup, choose a custom installation, choose to install into an NDS system, and only choose ip for the protocol. Do not install Workstation Manager.
2. On the Windows 2000 IIS 5.0 computer, open the Computer Management Snap-in (under Administrative Tools). Under Local Users, right-click the IUSER_Machine Name account, and then click Set Password. Change the password, save it, and then close the MMC.
3. In the Internet Services Manager, do the following:
   
   
   1. Right-click the server name (for example, MYWEB01) under Internet Information Services.
   2. Click the Edit button next to WWW to open the master properties.
   3. On the Directory Security tab, click the Edit button next to Anonymous and Authentication methods.
   4. On the Authentication Methods tab, click Edit under the Anonymous section to open the Anonymous User properties.
   5. Click to uncheck the option for IIS to control the password, and then enter the password that you changed in step 2.
4. Create an ODBC System DSN by using the Microsoft dBase VFP driver. Give the DNS a name and configure the following settings:
   
   
   • In the Database type section, choose Free Table Directory.
   • For the path, enter the Universal Naming Convention (UNC) to the Netware File System where the database resides.
   • Under options, click to uncheck the Fetch Data in Background setting.
5. Open the Netware Administrator located on the sys: volume in the Public\WIN32 folder of the Netware 5 Server. In the root of the container where the server exists, create an IUSR_Machine Name account that is identical to the one on the Windows NT Server computer. In the properties for that user, click Password Restrictions, and then make sure that only the Require password option is checked and nothing else. Click the Set Password button and set it to that of the Windows NT account. Do not require passwords to be changed on the Netware system.
   
   NOTE: This is the most crucial step to the entire process.
6. In Netware Administrator, open the properties for the newly created IUSER, click the Rights to files and directories tab, and then add the appropriate permissions to the database files that need to be accessed. Give at least Read permissions, unless changes will be made through the Internet, which requires all permissions except Supervisor and Access Control.NOTE: For access to be granted, the Netware Server requires that both the .dbf and .cdx files exist in the same directory. If only the .dbf file exists, the error message appears.