This may seem a little confusing but I'll try my best to explain.

I have the following scenario:
I have IIS 5 running on Win2k Pro. Authentication method is set at the website level as Integrated NT Authentication. The Win2k Pro box is a member server (not a domain controller) of the domain. The Win2k Pro box has a odbc system datasource (using Visual Foxpro driver) that is pointing to a share on a remote NT 4 Server box.
The security on the remote dbf file has been setup to be accessed by all domain users, including the IUSR_ account that was set up for IIS 5 on the Win2k Pro box.

I have an ASP page that is trying to access data from the dbf table on the remote NT 4 Server. A remote machine is to browse the page.

Here is the code in question:

SET cnERSData = server.CreateObject("ADODB.Connection")
cnERSData.ConnectionString = "DSN=ERSData"
cnERSData.Open
SET rsWhitefile = server.CreateObject("ADODB.Recordset")
rsWhitefile.Open "SELECT * FROM project where alpha = ""MINBOD02""", cnERSData
IF rsWhitefile.EOF THEN
Response.Write "No Records"'
ELSE
Response.Write "Records found"
END IF

SET rsWhitefile = nothing
SET cnERSData = nothing

The Connection and Recordset objects are created successfully. When trying to execute the query the following error shows up in the browser:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Visual FoxPro Driver]File 'project.dbf' does not exist.
/testpage.asp, line 14

The file definitely exists and the odbc data source is pointing to the correct location.

Although I am not sure what exactly is happening, I am led to beleive that this is a authentication/security issue between Win2k Pro and NT 4 Servers. If anyone has any idea why this is happening please let me know.

Thanks in advance

George