How To Configure ASP to Read Data File on a Novell Server (178045)

SUMMARY

Active Server Pages (ASP) needs a special configuration in order to access file-based data from a Novell server. Simply mapping a drive letter to a Novell share (utilizing Novell Client Services) will fail. You may receive one of the following errors:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

-or-

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] Disk or network error.

MORE INFORMATION

Because IIS runs as a service and impersonates Windows NT accounts, IIS must access the Novell server's resources via an NT Gateway setup by GSNW (Gateway Services for NetWare).

Step 1 - On the Novell Server

Create a new account or use any existing account.
Give this account "Trustee Directory Assignments" for the folder in which the database resides.
Give this account the following rights: Create, Erase, File Scan, Modify, Read, Write.
Create a Group called NTGATEWAY.
Add the user to this group.

Step 2 - On the NT Server

Install GSNW (Gateway Services for NetWare) if not already installed.
Open GSNW control panel. Set the preferred server to the Novel Server.
Click on Gateway and set the Gateway Account to the account created or modified in Step 1 - On the Novell Server.
Set the password for that account.
Click ADD, and map a drive letter to a Novell share. Note the drive letter.
Click OK twice to exit GSNW. You should now be able to create a new DSN that uses the gateway's mapped drive letter to access the database on the Novell server.