>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
