Re: Problem with IIS 6.0

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Walid (anonymous_at_discussions.microsoft.com)
Date: 06/05/04 

Date: Sat, 5 Jun 2004 03:51:03 -0700

Please see the following code:
''''''''''''''''''''''''''''
set oFoxConn = server.CreateObject ("ADODB.Connection")
oFoxConn.Open ("DSN=aaa")
Response.Write oFoxConn.State & "<hr>"
set oFoxRs = server.CreateObject ("ADODB.recordset")
oFoxRs.Open "select * from ORDHDR",oFoxConn
Response.Write oFoxRs.RecordCount & "<hr>"
oFoxRs.Clone
oFoxConn.Close
set oFoxConn = nothing
''''''''''''''''''''''''''
in the line : oFoxRs.Open "select * from ORDHDR",oFoxConn
I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Visual FoxPro Driver]File 'ordhdr.dbf' does not exist.

/asp2fox/conn.asp, line 5

1. The DSN is points to Map drive I got the above error.
2. The DSN is points to UNC path I got the above error.
3. The DSN is points to local drive works fine.